ddwebb Wrote:
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

Hi ddwebb

Try this

=IF(COUNTIF($A$1:$A$10,B1)=0,"No Match","Match")


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=399145