1. Suppose you have the numbers in ColA. Assign a header to the column.
Select the range in Col A including the header.
2. From menu DataFilterAdvanced FilterCopy to another location
3. In copy to I have selected D1 and check 'Unique records only'
4. Click OK will give you the unique list in Col D

If this post helps click Yes
---------------
Jacob Skaria


"mrsmasterg" wrote:

I have a spreadsheet in which duplicate data appears multiple times in
groups. I would like to count each occurence. Ex.
12345
12345
12345
12345
78912
78912
78912
78912
78912

expected result is that each occurence is counted once.
12345 occurs once
78912 occurs once

I do not want to use a pivot table because each 'group' has multiple rows of
data that needs to be shown.