I received an email yesterday regarding the above topic and I have a
spreadsheet that has hundreds of names (i.e. Doe, J) and I thought that
this would be a cool way to see what distinct names are listed within
the column of names.
I entered the following into the
=INDEX($A$1:$A$150,MATCH(0,COUNTIF($B$1:B1,$A$1:$A $150),0)) in field
B2.
Column A has a sample of names from A1 to A150
Column B, Row 1 is blank
Column B, Row 2 has this function. I copied the formula down to B150,
of course when I do so, the formula changes ($B$1:B2, ...). All the
fields in the Column B have the #N/A value.
I know that there are duplicate rows of data in Column A.
So what is wrong?

dw


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