ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   extract list of names and elimanate duplicates (https://www.excelbanter.com/excel-worksheet-functions/5119-re-extract-list-names-elimanate-duplicates.html)

Frank Kabel October 27th 04 04:32 PM

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



petty October 27th 04 04:52 PM

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



petty October 27th 04 04:52 PM

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




All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com