Use datafilteradvanced filter, copy to another location and unique records
only, if you want to count the list use countif on the whole list with the
unique list as criteria

Whole list is A2:A400, unique list is H2:H40, in I2 put

=COUNTIF($A$2:$A$400,H2)

copy down as long as needed

Regards,

Peo Sjoblom


"Arturo" wrote:

If I have a list of numbers
1
2
3
2
1
2

How would I generate a list unique records?
I.e.
2 of 1
3 of 2
1 of 3