View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default Checking for duplication on rows

Presume you're checking some specific names ?
One way to quickly check is to use autofilter (Data Filter Autofilter)
Select "Custom" from the droplist, then enter/paste the specific name OK
Then reset the droplist to "(All)", repeat the check for each col concerned
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Karmen" wrote in
message ...

Hello,

In a particular spreadsheet, I would like to verify if the same name is
listed on multiple rows. The name is entered in multiple columns on the
same row, that is acceptable, but I would like to know if the name is
entered on multiple rows regardless of the column. How can I check
this?

THANKS,
karmen


--
Karmen
------------------------------------------------------------------------
Karmen's Profile:

http://www.excelforum.com/member.php...o&userid=30972
View this thread: http://www.excelforum.com/showthread...hreadid=509495