Show a top N set by a cell
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
On the Report sheet, set B1 to 5 as the control for N, put the column headers in row 3, and use a formula starting in A4 to show the top N products by revenue.
Data
Starting sheet| A | B | |
|---|---|---|
| 1 | Product | Revenue |
| 2 | Alpha | 8100 |
| 3 | Beta | 12700 |
| 4 | Gamma | 9400 |
| 5 | Delta | 15300 |
| 6 | Epsilon | 11500 |
| 7 | Zeta | 6900 |
| 8 | Eta | 14100 |
| 9 | Theta | 10200 |
| 10 | Iota | 13300 |
| 11 | Kappa | 7600 |
Report
Starting sheet| A | |
|---|---|
| 1 |
A passing output
Autosheet in Excel · Opus 5.5A4=TAKE(_xlws.SORT(Data!A2:B11, 2, -1), B1)
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
Pass criteria
All must be met, checked automatically.Report!A4uses a formulaReport!B1matches the expected answerReport!A4:B8match the expected answers
Passed 22
Autosheet in Excel Opus 5.5 · Medium
A4=TAKE(_xlws.SORT(Data!A2:B11, 2, -1), B1)
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
Autosheet in Excel GPT-6 Astra · Low
A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
Autosheet in Sheets Opus 5.5 · Medium
A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), $B$1, 0, 2, FALSE)"),"Delta")
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Autosheet in Excel Sonnet 5.5 · Medium
A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),MIN($B$1,ROWS(Data!A2:B11)))
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Claude in Excel Opus 5.5 · High
A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
Autosheet in Excel Haiku 5.5 · High
A4=IF(ROWS(A$4:A4)>$B$1,"",XLOOKUP(LARGE(Data!$B$2:$B$11,ROWS(A$4:A4)),Data!$B$2:$B$11,Data!$A$2:$A$11))
| A | B | |
|---|---|---|
| 1 | N (top N control) | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
| 9 | ||
| 10 | ||
| 11 | ||
| 12 | ||
| 13 |
Claude in Sheets Opus 5.5 · Medium
A4=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(SORTN(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), $B$1, 0, 2, FALSE), """")"),"Delta")
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
Claude Code + Sheets MCP Opus 5.5 · Medium
A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), B1, 0, 2, FALSE)"),"Delta")
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Autosheet in Excel GPT-6.1 Sol · Medium
A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)
| A | B | |
|---|---|---|
| 1 | N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
A4=IFERROR(__xludf.DUMMYFUNCTION("LET(p, UNIQUE(FILTER(Data!A2:A1000, Data!A2:A1000<>"""")), r, MAP(p, LAMBDA(x, SUMIF(Data!A2:A1000, x, Data!B2:B1000))), SORTN(HSTACK(p, r), $B$1, 0, 2, FALSE))"),"Delta")
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Total Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
ChatGPT + Autosheet MCP GPT-6 · Medium
A4=IFERROR(__xludf.DUMMYFUNCTION("LET(products, UNIQUE(FILTER(Data!A2:A1000, Data!A2:A1000<>"""")), totals, ARRAYFORMULA(SUMIF(Data!A2:A1000, products, Data!B2:B1000)), SORTN(HSTACK(products, totals), $B$1, 0, 2, FALSE))"),"Delta")
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Total Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
Autosheet in Sheets Haiku 5.5 · High
A4=IF(ROWS($A$4:A4)>$B$1,"",INDEX(Data!$A$2:$A$11,MATCH(LARGE(Data!$B$2:$B$11,ROWS($A$4:A4)),Data!$B$2:$B$11,0)))
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
| 9 | ||
| 10 | ||
| 11 | ||
| 12 | ||
| 13 |
ChatGPT in Excel GPT-6 Astra · Medium
A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)
| A | B | |
|---|---|---|
| 1 | N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Claude in Excel Haiku 5.5 · High
A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),$B$1)
| A | B | |
|---|---|---|
| 1 | N (top products) | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Claude in Sheets Haiku 5.5 · High
A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(Data!A2:B11,$B$1,0,2,FALSE)"),"Delta")
| A | B | |
|---|---|---|
| 1 | N (top products to show) | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Autosheet in Excel GPT-6 Luna · High
A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),$B$1)
| A | B | |
|---|---|---|
| 1 | 5 | |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Copilot in Excel Auto
A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),B1)
| A | B | |
|---|---|---|
| 1 | N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15,300 |
| 5 | Eta | 14,100 |
| 6 | Iota | 13,300 |
| 7 | Beta | 12,700 |
| 8 | Epsilon | 11,500 |
ChatGPT + Drive MCP GPT-6 · Medium
A4=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(ARRAY_CONSTRAIN(SORT(FILTER(Data!A2:B1000,Data!A2:A1000<>""""),2,FALSE),$B$1,2),"""")"),"Delta")
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
ChatGPT in Excel GPT-6 Luna · High
A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),$B$1)
| A | B | |
|---|---|---|
| 1 | N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
Gemini in Sheets Auto
A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(Data!A2:B11, B1, 0, 2, FALSE)"),"Delta")
| A | B | |
|---|---|---|
| 1 | Top N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
ChatGPT in Sheets GPT-6 Astra · Medium
A4=IFERROR(__xludf.DUMMYFUNCTION("FILTER(SORT(Data!A2:B11,2,FALSE),SEQUENCE(ROWS(Data!A2:B11))<=$B$1)"),"Delta")
| A | B | |
|---|---|---|
| 1 | N | 5 |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
ChatGPT in Sheets GPT-6 Luna · High
A4=IF(ROWS($A$4:A4)<=$B$1,INDEX(Data!$A$2:$A$11,MATCH(LARGE(Data!$B$2:$B$11,ROWS($A$4:A4)),Data!$B$2:$B$11,0)),"")
| A | B | |
|---|---|---|
| 1 | 5 | |
| 2 | ||
| 3 | Product | Revenue |
| 4 | Delta | 15300 |
| 5 | Eta | 14100 |
| 6 | Iota | 13300 |
| 7 | Beta | 12700 |
| 8 | Epsilon | 11500 |
| 9 | ||
| 10 | ||
| 11 | ||
| 12 | ||
| 13 |