View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tera Tera is offline
external usenet poster
 
Posts: 8
Default Aggregation on Column Value (groub by logic)

Hi,
This does not server my purpose. Is it possible by developing some Macro?
and in that case may I expect any help?

"tera" wrote:

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?