Debra Dalgleish shows how you can extract a unique list using Advanced
filter he

http://www.contextures.com/xladvfilter01.html#FilterUR

The section below this shows how you can extract to another sheet. So,
supposing you have your unique list on another sheet in column A: in
B2 you can have this formula:

=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)

and copy this down.

Hope this helps.

Pete

On Mar 12, 5:38*pm, "tkraju via OfficeKB.com" <u16627@uwe wrote:
1 *name * * * * amount
2 * Paul * * * * *200
3 * John * * * * *100
4 * Mary * * * * *250
5 * Paul * * * * * 100
6 * John * * * * * 300

After entering above data w/sheet should save this data like below
1 name * * * * * amount
2 Paul * * * * * * 300
3 John * * * * * * 400
4 Mary * * * * * * 250

How to achieve this in Excel?

--
Message posted viahttp://www.officekb.com