Forum Discussion

TIGER-18's avatar
TIGER-18
Copper Contributor
Nov 13, 2023

highlight duplicates in sheets with 2 criteria

I Have a workbook with multiple sheets and I want to highlight the row if the value in column A "Shipment NO" & column E "SKU"  both have been duplicated in other sheets below is what I'm looking for...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 15, 2023

TIGER-18
I'll see what I can do.... Please confirm you're fine with using Tables (instead of Ranges)

Lorenzo's avatar
Lorenzo
Silver Contributor
Nov 15, 2023

TIGER-18 

 

I assumed Tables are fine as they offer comprehensive + dynamic ranges (amongst other benefits). Attached file contains what you asked (helper columns per sheet) and requires Excel 365

  • TIGER-18's avatar
    TIGER-18
    Copper Contributor
    Nov 21, 2023

    Lorenzo 

     

    hi
    thanks for your idea but there is an issue when I update any number of column E (SKU) the formula will reflect the error (Name?) please find the below photos:

     

    Table 2 & 3

     

    I prefer if there's a way to make a helper column with true and false and according to that, I will make conditional formatting against that column.

     

    please note the sheets are increasing so I want something easy to apply for any new sheets.

     

    thanks in advance.

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Nov 21, 2023

      Hi TIGER-18 

      Can't reproduce the issue here. Please share your workbook

      If you can't attach it here upload and share it with OneDrive, Google Drive or the like then post the sharing link here

       

      Thanks

Resources