Last time we learnt a technique to compare two lists for similar values using conditional formatting. You can learn more about it at this page. However the formula we employed had its limitations as it was checking for the values only in the same row. Data may be duplicated in a different row in another […]