I wanted a little more than Duplicate or unique. The original formula ws
to return the distinct values or duplicate values from column A.

I finally got it to work. what I did not know was that after entering
the original formula:
=INDEX($A$2:$A$8,MATCH(0,COUNTIF($B$2:B4,$A$2:$A$8 ),0))
I was to press the SHIFT+CTRL+ENTER keys to make this an array and then
copy the formula down to B150.
This now shows all the Unique values in Column A displayed in Column
B.
Just one tiny step that the ExcelTip e-mail did not provide and I did
not know.
Thanks
dw :)


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