Trisher,

A pivot table can give you the total quantities for each number.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"trisher75" wrote in message
...
I need some help. I have a spreedsheet with identical numbers with
diffrent
qty's in another colume. Is there a quick way to search for the same # and
add the qty's. the sheet is like 2500 lines long and by the looks of it
every part # has a duplicate.

Please help me