Duplicate inventory items, need total on quantity and amount

**Glendaann** · 03-03-2013, 03:19 PM

Can someone please help me with excel. I am using excel 2000. I know the very basics in excel. I need help on listing the inventory items not duplicating and getting a total on the quantity and amount. I have seen this problem solved and tried the formulas but I couldn't get them to work. I have attached part of an excel sheet. I also tried the formula =IF(A2<>A1,0,1) which picked up the duplicates, but I wasn't for sure how to write my next statement. Any help would be greatly appreciated!

**AB33** · 03-03-2013, 03:24 PM

Try this one

Please Login or Register  to view this content.

**Glendaann** · 03-03-2013, 03:45 PM

Where do you put this in at?

**AB33** · 03-03-2013, 03:48 PM

See attached

**Glendaann** · 03-03-2013, 03:58 PM

AB33, Thank you for you help, that is exactly what I needed! Thank you so much!

**AB33** · 03-03-2013, 04:08 PM

Glen,
You are welcome!
Could you please now close this thread as solved? Go in to the top right-hand side of this page, choose "Thread Tools" then you select solved from the drop down menu.