It sounds to me like you would be better off using the advanced filter. There you can specify criteria that will cause only certain
rows to be displayed. It won't delete anything, but I believe it allows you to build formulas that only operate on the displayed
rows. Advanced filter also allows you to copy the unique items to another area of your worksheet if that helps. Then you could
filter those rows or build formulas there. Another solution for you would be to just use a simple pivot table. That would let you
pretty much do whatever you want, relative to your description of your problem. My only work of caution with pivot tables is that
they can be tricky if you create external formulas which reference values in the table. They also take a little time to get used to,
but I think you would find one very helpful for your situation.

HTH
--
RMC,CPA


"Josh" wrote in message ...
I have a list of data consisting of part#'s, vendor, qty, etc...

I would like to total the qty for each part#, and then delete all the other
lines so I have a collapsed list; where each part# is listed once, with the
total.

The subtotal function gives me the totals I need but then gets in the way
for other data manipultion needs.

Is there a way to SUM the Qty column for rows w/ the same Part# then delete
all the rows where the Part# is duplicated?