K
Krista
I need to check for duplicate names in a column. Is there a way to do this?
M
Manish Bajpai
Copy that column into a new worksheet...I don't want you to mess up your
exisiting sheet.
Then, simply create a Pivot with the data of that single column. You will
have to fist take it on rows and thewn again drag into data box as Count.
That's it.
Thanks,
Manish Bajpai
exisiting sheet.
Then, simply create a Pivot with the data of that single column. You will
have to fist take it on rows and thewn again drag into data box as Count.
That's it.
Thanks,
Manish Bajpai
D
David Billigmeier
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")
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")
D
David Billigmeier
Sorry... I see a typo, paste that code in B1 
M
Manish Bajpai
David,
You are simply great !!
Nice to brainstorm with you.
Thanks,
Manish
You are simply great !!
Nice to brainstorm with you.
Thanks,
Manish
D
David Billigmeier
Definitelly, nice to have met a fellow Excel fanatic!
Regards,
Dave
Regards,
Dave