Use this in cell B2, and copy down:

=IF(COUNTIF($A$1:A2,A2)=1,A2,"")


--
HTH,
Bernie
MS Excel MVP


"ddwebb" wrote in message
...

I tried that and that did not work.

What the Excel Tip e-mail was:
Problem:
Column A contains a list of values, each of which may appear more than
once.
We want to create a list in column B in which each value from column A
may only appear once.

Solution:

Use the INDEX, MATCH, and COUNTIF functions as shown in the following
Array formula:
{=INDEX($A$2:$A$8,MATCH(0,COUNTIF($B$2:B2,$A$2:$A$ 8),0))}

Note:
The first cell in the unique list (column B) must remain empty.
The formula should be entered in the second cell and copied down until
the #N/A error is returned.


List_________Distinct List
Red
Blue_________Red
Green________Blue
Yellow_______Green
Green________Yellow
Blue_________#N/A
Blue

I have tried this in a separate worksheet to experiment and it does not
work for me. Using Excel 2002.
dw


--
ddwebb
------------------------------------------------------------------------
ddwebb's Profile: http://www.excelforum.com/member.php...fo&userid=9057
View this thread: http://www.excelforum.com/showthread...hreadid=399145