Find duplicates formula

[hannu]

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]

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

[hannu]

thanks Kimberly, works fine.