Forum Discussion

Mr_Raj_C's avatar
Mr_Raj_C
Brass Contributor
Apr 20, 2026

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 are formatted differently. 

I want to know which addresses from the Master are missing from Sheet 2.

I'm not sure what is the best way to approach this without having to format the whole thing.

Hope the above makes sense ?!

I wanted to attach the workbook but can't seem to upload anything.

Thanks Raj

excel

3 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 20, 2026

    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

     

    • Mr_Raj_C's avatar
      Mr_Raj_C
      Brass Contributor
      Apr 20, 2026

      Thanks Sergei,

      Have they restricted the ability to add attachments ?

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 20, 2026

        It depends. Experienced users of this resource are allowed to add attachments, the rest are not. I have no idea what is the logic behind.

        Anyway, you always could place the file on OneDrive, GoogleDisk, whatever, give access for everyone and share the link here.