Hi All,
Hope you are doing well!...I am trying to identify a formula to identify the top 5 vendors for the categories Backorder and Pre-sell according to the amounts refunded ...Also I am trying the find the top 70% of the items contribution by Pre-sell and Backorder category..This will list the itemid with the number of times the itemid appears in the list with the refunds sorted in descending order contributing to the top 70% for each individual category Pre-sell and Backorder..
I have all the input data in the main sheet and the required outputs in the next three tabs...Can you please help me with the formula for the same..
Thanks,
Arun
Bookmarks