Hi,
Require a formula help for dynamic overview table that sorts automatically based on total values from all the weeks stated as headers in a table(Quantities) and refreshes instantly always as per entering the values, and change the positions of each product as per their sum of total quantities.
Finally in an total weeks which product stands for producing largest sum of quantity that would be recorded as in overview table serial number 1 position as like same manner second highest would be second position as like mentioned in expected results.
In a work sheet cells A1 to k8 that are the cells belongs to Overview table where the results to be reflect and expected results are mentioned there.
And the data from where results to be reflect in overview table beginning from Cells C10 to J20 as named (Lot-1 and Lot-2).
Thanks for the help.
Bookmarks