Create a new list that singles out duplicate numbers
 

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)


--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=396849

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xladvfilter01.html#FilterUR

moglione1 wrote:

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)

--
moglione1
------------------------------------------------------------------------
moglione1's Profile: http://www.excelforum.com/member.php...o&userid=26414
View this thread: http://www.excelforum.com/showthread...hreadid=396849

--

Dave Peterson