Top N inside each group | Sheet toolbox

Compute a separate ranking inside each region or team; for example, keep the two strongest stores in the east and in the west.

Rank inside each group and keep the top N, such as the two highest-selling stores in every region.

Upload one Excel workbook that has an identity, a group, and an amount. Each group is ranked on its own.

Download the template pack for a filled sample workbook and a header-only blank workbook. Map the required columns, compute in the browser, then export a result sheet. No signup.