Aggregation on Column Value (groub by logic)
 

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?

Aggregation on Column Value (groub by logic)
 

On Dec 7, 4:39 am, 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?

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

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?