Excel Intermediate:
#2:Compare two lists instantly
Solution:
1. Select range in both lists
2. Go to Conditional Formatting > Highlight Cells Rules > Duplicate Values > OK
Play this trick immediately to do your quick comparison instantly
Benefits:
-
No need to spend time in writing formulas /code
-
Instant way
Alternatively you can watch my below video for better clarity.
if the video is not visible please click here.
Please leave your comments below if this tip is useful.