#1
|
|||
|
|||
Find duplicates formula
I have a database of 1000 rows where first name and last name are in separate but adjacent cells. how do i find duplicates so that I can identify if the same person's name is duplicated?
H |
#2
|
|||
|
|||
=countifs($a$1:$a$1000,a1,$b$1:$b$1000,b1)
|
#3
|
|||
|
|||
thanks Kimberly, works fine.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
can Find/Replace NOT find something? | Bobosmite | Word | 6 | 05-27-2010 08:09 PM |
Macro to remove duplicates in Refrences list | HowardC | Word VBA | 0 | 05-20-2010 09:57 AM |
Send/Receive Duplicates All Email | javauno | Outlook | 2 | 07-17-2009 07:16 PM |
Needs help to find excel formula- Please | aamer_1983 | Excel | 2 | 07-13-2009 01:46 AM |
sum of duplicates | zxmax | Excel | 1 | 09-29-2006 08:29 PM |