I have Column A "Fist Name" and Column B "Last Name". For example
<tbody>
</tbody>
I want to highlight or indicate in a 3rd column the records that Are Either an exact match like in rows 3 "David Ackary" and row 4 "David Ackary"
AND I would also like to identify those records that COULD be a match like row 1 "April & Pat Abernathy" and row 2 "Pat Abernathy"
FIRST NAME | LAST NAME |
Arpil & Pat | Abernathy |
Pat | Abernathy |
David | Ackary |
David | Ackary |
Karen | Smith |
Bob | Barker |
Ellen | Barker |
Jack | Smith |
David | Brady |
<tbody>
</tbody>
I want to highlight or indicate in a 3rd column the records that Are Either an exact match like in rows 3 "David Ackary" and row 4 "David Ackary"
AND I would also like to identify those records that COULD be a match like row 1 "April & Pat Abernathy" and row 2 "Pat Abernathy"