Forum Discussion

Mollie1247's avatar
Mollie1247
Copper Contributor
May 12, 2021

Complex (Possibly) Formula Assistance Required - Find Duplicates

Hi all!   New to the community and really hoping someone can help!   I currently have 2 sheets in Excel (I think 365) that I am hoping to find duplicates on, let's just call them Sheet 1 and Shee...
admin
excel
Formulas and Functions
Mollie1247's avatar
Mollie1247
Copper Contributor
May 18, 2021
I've never used power query before...

There's actually more than one sheet - but all will be compared to sheet 1.

All sheets vary from 50 rows - a couple of thousand....
Yea_So's avatar
Yea_So
Bronze Contributor
May 18, 2021

Hi Mollie1247 

 

How many sheets? I imagine all the sheets have identical in tables (columns)?

  • Mollie1247's avatar
    Mollie1247
    Copper Contributor
    May 18, 2021
    5 sheets - currently they aren't all identical but they can be with little effort if that makes it easier 🙂
    • Yea_So's avatar
      Yea_So
      Bronze Contributor
      May 20, 2021

      Hi Mollie1247 

       

      From what I can understand in how you're describing the geography of Sheet1, this is how it looks:

      and Sheet2, this is how it looks:

      My question is:

      are all the other Sheets similar to Sheet2?  Thanks

    • Yea_So's avatar
      Yea_So
      Bronze Contributor
      May 18, 2021

      Hi Mollie1247  can you share it?

      • Mollie1247's avatar
        Mollie1247
        Copper Contributor
        May 18, 2021
        Unfortunately, no.

        It contains confidential information.

Resources