How do I locate duplicate records in Excel?
I would make a column combining name and last name in column D, =B&C and then
would use conditional formatting formula is highlight the column go to format
conditional formatting chnage cell value is to formula is and use this
formula and =COUNTIF($d$1:$d$14,d1)1 click on format and choose a color.
Nikki
"Amie G" wrote:
I'm trying to locate duplicate records in my spreadsheet. It has 15 columns
and almost 3000 rows. Row B is Last Name and Row C is First Name. I need to
highlight any records that have the same last and first names. So if there
are multiple Bob Jones I want to check and see if they are the same person.
How do I do this? I've tried all kinds of methods suggested on the web and
have not been able to find a solution. Thanks!
|