Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / December 2007

Tip: Looking for answers? Try searching our database.

Aggregation on Column Value (groub by logic)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tera - 07 Dec 2007 04:39 GMT
Hi ,
  I have got a requirement as follows
My input data is as
A/C Code   Value
1                 100
1                150
1                 75
2                100
2                200

I have a  defined format for output  (in same worksheet of where the above
template is located) as
A/C Code    Title  o/p Value

A/C code should be displayed only once and o/p value should be aggregated
value on A/C code (A/C should be available in the ouput template)
the expected out put should be
A/C Code    Title    O/p Value
1                 AAA   325
2                ABB     300             (A/C Code and Title would be pre
-existed in the target template)
Can anybody help me plz?
paul.robinson@it-tallaght.ie - 07 Dec 2007 10:11 GMT
> Hi ,
>    I have got a requirement as follows
[quoted text clipped - 18 lines]
> -existed in the target template)
> Can anybody help me plz?

Hi
Have you tried using a Pivot Table?
Select your two columns with headers and do Data, Pivot Table and
Pivot Chart Report. Click Next. Click Next. Choose where you want the
table. In Layout drag A/C Code to the Row area and Value to the Data
area. Click Finish.

regards
Paul
tera - 13 Dec 2007 17:39 GMT
Hi,
 This does not server my purpose. Is it possible by developing some Macro?
and in that case may I expect any help?

> Hi ,
>    I have got a requirement as follows
[quoted text clipped - 18 lines]
> -existed in the target template)
> Can anybody help me plz?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.