Add values of data that might have duplicate labels
 

Hello,

I have two columns.
A contains an ID number (could have duplicates throughout the rows)
B contains a payble amount

In A column there are duplicate entries but could have different payble
amounts (clumn B).

I need to add all the amounts per ID number (unique and/or duplicate).

Any suggestions?

Add values of data that might have duplicate labels
 

A pivot table gives you the report you seek in a matter of seconds

Assume the 2 col headers are ID, Amt
Select any cell within the source table. Click Data Pivot table. Click
NextNext. In step 3 of the wiz., click Layout, then:
Drag n drop ID in ROW area
Drag n drop Amt in DATA area
Click OK Finish. That's it
Hop over to the pivot sheet (just to the left) for the results:
Unique IDs will be listed in left col, with corresponding total amounts next
to it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Tony" wrote:
I have two columns.
A contains an ID number (could have duplicates throughout the rows)
B contains a payble amount

In A column there are duplicate entries but could have different payble
amounts (clumn B).

I need to add all the amounts per ID number (unique and/or duplicate).

Any suggestions?

Add values of data that might have duplicate labels
 

Max thank you for the swift answer. I am not familiar with pivot tables
therefore I was not able to come with this solution. Still there is one more
parameter, which I know how to solve it if I had a formula for my initial
question.

There is a certain figure above which, I would like the id to be
characterized (on a different column) with the number "1".

Can we do this through the same pivot table?

Thanks in advance for your time
"Max" wrote:

A pivot table gives you the report you seek in a matter of seconds

Assume the 2 col headers are ID, Amt
Select any cell within the source table. Click Data Pivot table. Click
NextNext. In step 3 of the wiz., click Layout, then:
Drag n drop ID in ROW area
Drag n drop Amt in DATA area
Click OK Finish. That's it
Hop over to the pivot sheet (just to the left) for the results:
Unique IDs will be listed in left col, with corresponding total amounts next
to it
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"Tony" wrote:
I have two columns.
A contains an ID number (could have duplicates throughout the rows)
B contains a payble amount

In A column there are duplicate entries but could have different payble
amounts (clumn B).

I need to add all the amounts per ID number (unique and/or duplicate).

Any suggestions?

Add values of data that might have duplicate labels
 

There is a certain figure above which, I would like the id to be
characterized (on a different column) with the number "1".
Can we do this through the same pivot table?

I'm not sure whether you're asking for the COUNT of IDs? If so, right-click
anywhere inside the pivot PT wizard Layout, then just drag n drop ID
into the DATA area (it'll appear as COUNT of ID). Click OK Finish.

If the above isn't what you're after, suggest you put in as a fresh posting,
and illustrate it with some sample data & desired results
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Tony" wrote in message
...
Max thank you for the swift answer. I am not familiar with pivot tables
therefore I was not able to come with this solution. Still there is one
more
parameter, which I know how to solve it if I had a formula for my initial
question.

There is a certain figure above which, I would like the id to be
characterized (on a different column) with the number "1".

Can we do this through the same pivot table?

Thanks in advance for your time

Add values of data that might have duplicate labels
 

Max,

Thank you v.much for your help.

By trying about the pivot table I got the info that I required...

THX
Tony

"Max" wrote:

There is a certain figure above which, I would like the id to be
characterized (on a different column) with the number "1".
Can we do this through the same pivot table?

I'm not sure whether you're asking for the COUNT of IDs? If so, right-click
anywhere inside the pivot PT wizard Layout, then just drag n drop ID
into the DATA area (it'll appear as COUNT of ID). Click OK Finish.

If the above isn't what you're after, suggest you put in as a fresh posting,
and illustrate it with some sample data & desired results
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Tony" wrote in message
...
Max thank you for the swift answer. I am not familiar with pivot tables
therefore I was not able to come with this solution. Still there is one
more
parameter, which I know how to solve it if I had a formula for my initial
question.

There is a certain figure above which, I would like the id to be
characterized (on a different column) with the number "1".

Can we do this through the same pivot table?

Thanks in advance for your time

Add values of data that might have duplicate labels
 

Welcome, Tony
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Tony" wrote in message
...
Max,
Thank you v.much for your help.
By trying about the pivot table I got the info that I required...

THX
Tony