Forum Discussion

A_SIRAT's avatar
A_SIRAT
Iron Contributor
Oct 14, 2023
Solved

Help to consolidate Data into one sheet.

Hi, I have attached an example file and would really appreciate your help. I have explained what I want on the last sheet named consolidated data. thanks in advance.
excel
Formulas and Functions
A_SIRAT's avatar
A_SIRAT
Iron Contributor
Oct 18, 2023

Lorenzo 

 

Thank you very much. I have done a few tests and it works perfectly 🙂

Would you be so kind and help me with the last request. I have just thrown a spanner in the works by adding a column named Master Data where I have indicated which varieties are divisible by 200 and others by 100.

    • A_SIRAT's avatar
      A_SIRAT
      Iron Contributor
      Oct 18, 2023
      It's end of the story... (lol)
      Highly appreciated !
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Oct 18, 2023

        A_SIRAT 

         

        On reflection - although I have no idea if you need this - I updated the formula for Total [Quantity] on 'Consolidation' so it works with filtered data

         

        Hope this helps

Resources