extract list of names and elimanate duplicates
 

Hi
use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"petty" schrieb im Newsbeitrag
...
Hi.

I got a spreadsheet wherby i put my invoices and products from my
supliers in.

Like
Supliers Product Total
Almond Fish 5000
Pierce Beef 2000
Almond Fish 5000
anton Beef 1000
peter Groceries 1000


Now i need to ectract the names to a sheet and total the purchases in
one colom
like

Suplier
Almond 10 000
Pierce 2000
anton 1000
peter 1000

This is to check if my recons is ok. I have a months purchace on one
sheet. There is alot of duplicate names and some is just single
entries. I can do the lookup funtion on the name, but i strugle to
ectract the names to show list with no duplicates. Be so kind to
share
what your lookup funtion might be as well

Thanks alot
Martin

Thanks so much frank. It was the last place i would look

On Wed, 27 Oct 2004 17:32:21 +0200, "Frank Kabel"
wrote:

Hi
use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Thanks so much frank. It was the last place i would look


On Wed, 27 Oct 2004 17:32:21 +0200, "Frank Kabel"
wrote:

Hi
use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm