Create a new list that singles out duplicate numbers

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

KEEP duplicate records 3
Return a value if item does not appear on list 1
Copying and pasting ??? 3
How to blank out cells with duplicate values? 8
return comma separated list 2
Display a list in one column 1
Frequency Counting 8
Count unique numbers for execs 2

Top