Link to home
Start Free TrialLog in
Avatar of Evan Cutler
Evan CutlerFlag for United States of America

asked on

Excel Highlight Row when values are duplicate

Greetings,
I have an extremely large excel spreadsheet with 32 columns across adn over 8000 records down.

what I want to do is select the LastName, FirstName, and MiddleInitial columns, then highlight those rows that have duplicate Name (When all three match another row.

I can get a single field, but not three...how do I do this?
Thanks.
ASKER CERTIFIED SOLUTION
Avatar of E C
E C
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Evan Cutler

ASKER

That'll work.
thanks.