Create a new list that singles out duplicate numbers

  • Thread starter Thread starter moglione1
  • Start date Start date
M

moglione1

Hi all.

Does anybody know if you can create a list of numbers based on another
set. E.g.

I have a list

1234
1234
1234
1234
1235
1235
1235
1101
1101
1000
1000

What I want to do is create a list that only shows the first occurence
of each number in a new list (lets say the one above appears in column
A, the new list should appear in column B)
 
Back
Top