Forum Discussion

jbbarnabas's avatar
jbbarnabas
Copper Contributor
Aug 15, 2020

Data compare

Good day community.   I need assistance please. Is there a formula that i can use to compare two sheets for dupplicate data rows. The compare formula needs to take all the data of the second shee...
Formulas and Functions
  • jbbarnabas's avatar
    jbbarnabas
    Copper Contributor
    Aug 15, 2020

    Ramiz_Assafthank you so much.

    Will apply and give feedback

    • Ramiz_Assaf's avatar
      Ramiz_Assaf
      Iron Contributor
      Aug 15, 2020

      jbbarnabas 

      If it works fine, please mark as solved!

      • jbbarnabas's avatar
        jbbarnabas
        Copper Contributor
        Aug 17, 2020

        Ramiz_Assaf 

        Hi Ramizassaf.

        No my problem has not been solved.

        The formulas (X-lookup and CONCAT) used in your spreadsheet is not available in my version of Excel, currently using Excel 2016.

         

        Thank you

Resources