I don't know if you want to do it manually or with a macro. I will
explaing the manual method

1) You need to create a list of unique numbers. the advance method
does this nicely but only on the same worksheet. So select the list of
original numbers then from menu Data - Advance Filter select the Unique
button and select copy to another location choose new location and
press OK. Now copy the unique list to the 2nd worksheet.


2) Now you can use the Countif formula to get the quantities.

=countif(Sheet1!A$1:A$1000, A1)

Place formula in column B along side the list of unique numbers. Then
copy the formula down the column on sheet 2.


The formula will count all the values in sheet 1 that matches the
unique numbers in sheet 2.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=179841

Microsoft Office Help