All AutosheetBench tasks

Show a top N set by a cell

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

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
AB
1ProductRevenue
2Alpha8100
3Beta12700
4Gamma9400
5Delta15300
6Epsilon11500
7Zeta6900
8Eta14100
9Theta10200
10Iota13300
11Kappa7600

Report

Starting sheet
A
1

A passing output

Autosheet in Excel · Opus 5.5
Report14 cells changed

A4=TAKE(_xlws.SORT(Data!A2:B11, 2, -1), B1)

AB
1Top N5
2
3ProductRevenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

How each AI configuration did

22 of 22 passRun files
Excel and Sheets · All types · All models · All outputs

Pass criteria

All must be met, checked automatically.
  • Report!A4 uses a formula
  • Report!B1 matches the expected answer
  • Report!A4:B8 match the expected answers

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed18s · 5¢
Report14 cells changed

A4=TAKE(_xlws.SORT(Data!A2:B11, 2, -1), B1)

AB
1Top N5
2
3ProductRevenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

Autosheet in Excel GPT-6 Astra · Low

Passed12s · 8¢
Report14 cells changed

A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)

AB
1Top N5
2
3ProductRevenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

Autosheet in Sheets Opus 5.5 · Medium

Passed23s · 5¢
Report14 cells changed

A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), $B$1, 0, 2, FALSE)"),"Delta")

AB
1Top N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Autosheet in Excel Sonnet 5.5 · Medium

Passed7s · 1¢
Report14 cells changed

A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),MIN($B$1,ROWS(Data!A2:B11)))

AB
1Top N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Claude in Excel Opus 5.5 · High

Passed15s · 14¢
Report14 cells changed

A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)

AB
1Top N5
2
3ProductRevenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

Autosheet in Excel Haiku 5.5 · High

Passed17s · 0.3¢
Report24 cells changed

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))

AB
1N (top N control)5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500
9
10
11
12
13

Claude in Sheets Opus 5.5 · Medium

Passed24s · 6¢
Report14 cells changed

A4=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(SORTN(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), $B$1, 0, 2, FALSE), """")"),"Delta")

AB
1Top N5
2
3ProductRevenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed28s · N/A
Report14 cells changed

A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), B1, 0, 2, FALSE)"),"Delta")

AB
1Top N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Autosheet in Excel GPT-6.1 Sol · Medium

Passed18s · 3¢
Report14 cells changed

A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)

AB
1N5
2
3ProductRevenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed56s · N/A
Report14 cells changed

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")

AB
1Top N5
2
3ProductTotal Revenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed44s · N/A
Report14 cells changed

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")

AB
1Top N5
2
3ProductTotal Revenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

Autosheet in Sheets Haiku 5.5 · High

Passed34s · 0.3¢
Report24 cells changed

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)))

AB
1Top N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500
9
10
11
12
13

ChatGPT in Excel GPT-6 Astra · Medium

Passed25s · 42¢
Report14 cells changed

A4=TAKE(_xlws.SORT(Data!A2:B11,2,-1),$B$1)

AB
1N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Claude in Excel Haiku 5.5 · High

Passed9s · 0.4¢
Report14 cells changed

A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),$B$1)

AB
1N (top products)5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Claude in Sheets Haiku 5.5 · High

Passed29s · 0.4¢
Report14 cells changed

A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(Data!A2:B11,$B$1,0,2,FALSE)"),"Delta")

AB
1N (top products to show)5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Autosheet in Excel GPT-6 Luna · High

Passed16s · 0.2¢
Report13 cells changed

A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),$B$1)

AB
15
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Copilot in Excel Auto

Passed21s · N/A
Report14 cells changed

A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),B1)

AB
1N5
2
3ProductRevenue
4Delta15,300
5Eta14,100
6Iota13,300
7Beta12,700
8Epsilon11,500

ChatGPT + Drive MCP GPT-6 · Medium

Passed35s · N/A
Report14 cells changed

A4=IFERROR(__xludf.DUMMYFUNCTION("IFERROR(ARRAY_CONSTRAIN(SORT(FILTER(Data!A2:B1000,Data!A2:A1000<>""""),2,FALSE),$B$1,2),"""")"),"Delta")

AB
1Top N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

ChatGPT in Excel GPT-6 Luna · High

Passed15s · 0.4¢
Report14 cells changed

A4=TAKE(SORTBY(Data!A2:B11,Data!B2:B11,-1),$B$1)

AB
1N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

Gemini in Sheets Auto

Passed1m 37s · N/A
Report14 cells changed

A4=IFERROR(__xludf.DUMMYFUNCTION("SORTN(Data!A2:B11, B1, 0, 2, FALSE)"),"Delta")

AB
1Top N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 12s · 55¢
Report14 cells changed

A4=IFERROR(__xludf.DUMMYFUNCTION("FILTER(SORT(Data!A2:B11,2,FALSE),SEQUENCE(ROWS(Data!A2:B11))<=$B$1)"),"Delta")

AB
1N5
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500

ChatGPT in Sheets GPT-6 Luna · High

Passed40s · 0.5¢
Report23 cells changed

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)),"")

AB
15
2
3ProductRevenue
4Delta15300
5Eta14100
6Iota13300
7Beta12700
8Epsilon11500
9
10
11
12
13