Add values of data that might have duplicate labels

[Tony]

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?

 

[Max]

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
Next>Next. 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]

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]

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]

Max,

Thank you v.much for your help.

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

THX
Tony

 

[Max]

Welcome, Tony
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik