Forum Discussion
Help comparing 2 different data sets
Dear Excel community, Hope everyone is keeping well :) I'm looking for some help comparing two different data sets (addresses to be precise). Sheet 2 contains a service list. Unfortunately they ...
Few ways. You may highligt values in Master which are not in Service. Assuming Master is in column A conditional formatting rule applied to Master could be
=COUNTIFS( ServiceList, $A1)=0