Hi thanks for the video.... quick question - what if I have to compare values across 2 columns to check if there are duplicates? and similarly, if I want to find out of there are duplicates across worksheets? Thanks!!!
what if the duplicate is written in a different format like for example, i have JOHN, DOE and DOES JOHN, and JOHN, DOES SR.,,,all are the same people how would i highlight them all.
Hi thanks for the video.... quick question - what if I have to compare values across 2 columns to check if there are duplicates? and similarly, if I want to find out of there are duplicates across worksheets? Thanks!!!
MrVisuallearning 5 months ago
what if the duplicate is written in a different format like for example, i have JOHN, DOE and DOES JOHN, and JOHN, DOES SR.,,,all are the same people how would i highlight them all.
MrRriche 5 months ago
yes nice but !!!! what if several persons live on the same street
you choose a pretty "bad example"
or if i have the same name 3times with diferent phone number
or what if the person has moved and has another adress ??
thekjub 1 year ago
Easy to follow. Showing the steps at the bottom was a nice touch.
Ray2isme 1 year ago