Find duplicates formula

hannu · #1 10-25-2010, 09:17 PM

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

Kimberly · #2 10-26-2010, 02:28 AM

=countifs($a$1:$a$1000,a1,$b$1:$b$1000,b1)

hannu · #3 10-26-2010, 02:48 AM

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