David,

You are simply great !!

Nice to brainstorm with you.

Thanks,

Manish

"David Billigmeier" wrote:

Sorry... I see a typo, paste that code in B1 :-)


--
David Billigmeier


"David Billigmeier" wrote:

Without using pivot tables:

Assume your values are in the range A1:A10, paste this code in A1 and drag
down:

=IF(COUNTIF($A$1:$A$10,A1)1,"dup","nodup")

--
David Billigmeier


"Krista" wrote:

I need to check for duplicate names in a column. Is there a way to do this?