Table to show recorded values per quarter

Hi. I have a report which works as inventory taken log in sheet1. Using this data, in sheet2, i need some help to get the records extracted per quarter (Example in Columns A:D for Q1) to show like a league table whereby the highest value items are shown first followed by the lower valued items. I would also like it to toggle maybe with a button at the side to also be able to show the number of items (Highest to lowest) as well. I have input expected results in sheet 3. Help will be greatly appreciated. Thank you.

Hi M,

Alternatively you could use Pivot Tables - please see attached (Sheet2).

Regards

peterrc

Thank You Bo. This worked Perfect.

Hi Bo,

I have one more query. If I need the League table to show for the whole year instead of per quarter, how could I amend the formula to do so.