All AutosheetBench tasks

Keep each product's latest record

FormulasEasyDeterministic scoringLatest run

Passed by all 12 products on their best model.

Prompt and starting spreadsheet

Task files

Prompt

On the Report sheet, keep one row per product using its latest record and list the products alphabetically. Put the headers in row 1 and use a formula starting in A2.

Data

Starting sheet
ABC
1ProductDateRevenue
2Alpha2025-03-018100
3Beta2025-03-016200
4Alpha2025-03-058300
5Gamma2025-03-027100
6Beta2025-03-076450
7Gamma2025-03-087500
8Delta2025-03-039200
9Delta2025-03-099400
10Alpha2025-02-207900
11Beta2025-02-216000

Report

Starting sheet
A
1

A passing output

Autosheet in Excel · Opus 5.5
Report15 cells changed

A2=LET(_xlpm.d, _xlws.FILTER(Data!A2:C1000, Data!A2:A1000<>""), _xlpm.s, SORTBY(_xlpm.d, INDEX(_xlpm.d,,1), 1, INDEX(_xlpm.d,,2), -1), _xlpm.p, INDEX(_xlpm.s,,1), _xlws.FILTER(_xlpm.s, _xlpm.p<>VSTACK("", DROP(_xlpm.p,-1))))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

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!A2:C5 hold the expected values
  • Report!A2 uses a formula

Passed 22

Autosheet in Excel Opus 5.5 · Medium

Passed28s · 6¢
Report15 cells changed

A2=LET(_xlpm.d, _xlws.FILTER(Data!A2:C1000, Data!A2:A1000<>""), _xlpm.s, SORTBY(_xlpm.d, INDEX(_xlpm.d,,1), 1, INDEX(_xlpm.d,,2), -1), _xlpm.p, INDEX(_xlpm.s,,1), _xlws.FILTER(_xlpm.s, _xlpm.p<>VSTACK("", DROP(_xlpm.p,-1))))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Autosheet in Excel GPT-6 Astra · Low

Passed22s · 14¢
Report15 cells changed

A2=LET(_xlpm.records,SORTBY(Data!A2:C11,Data!B2:B11,-1,ROW(Data!A2:A11),-1),_xlpm.products,INDEX(_xlpm.records,0,1),_xlws.SORT(_xlws.FILTER(_xlpm.records,XMATCH(_xlpm.products,_xlpm.products)=SEQUENCE(ROWS(_xlpm.records))),1,1))

ABC
1ProductDateRevenue
2Alpha2025-03-058,300.00
3Beta2025-03-076,450.00
4Delta2025-03-099,400.00
5Gamma2025-03-087,500.00

Autosheet in Sheets Opus 5.5 · Medium

Passed19s · 5¢
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(SORTN(SORT(FILTER(Data!A2:C1000, Data!A2:A1000<>""""), 2, FALSE), 9^9, 2, 1, TRUE), 1, TRUE)"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Autosheet in Excel Sonnet 5.5 · Medium

Passed10s · 2¢
Report15 cells changed

A2=LET(_xlpm.s,SORTBY(Data!A2:C11,Data!B2:B11,-1),_xlpm.u,_xlws.SORT(UNIQUE(Data!A2:A11)),HSTACK(_xlpm.u,XLOOKUP(_xlpm.u,INDEX(_xlpm.s,,1),INDEX(_xlpm.s,,2)),XLOOKUP(_xlpm.u,INDEX(_xlpm.s,,1),INDEX(_xlpm.s,,3))))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Claude in Excel Opus 5.5 · High

Passed23s · 12¢
Report15 cells changed

A2=LET(_xlpm.p,Data!A2:A11,_xlpm.d,DATEVALUE(Data!B2:B11),_xlpm.r,Data!C2:C11,_xlpm.u,_xlws.SORT(UNIQUE(_xlpm.p)),_xlpm.ld,MAP(_xlpm.u,LAMBDA(_xlpm.x,MAX(_xlws.FILTER(_xlpm.d,_xlpm.p=_xlpm.x)))),_xlpm.rev,XLOOKUP(_xlpm.u&"|"&_xlpm.ld,_xlpm.p&"|"&_xlpm.d,_xlpm.r),HSTACK(_xlpm.u,_xlpm.ld,_xlpm.rev))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Autosheet in Excel Haiku 5.5 · High

Passed29s · 0.4¢
Report15 cells changed

A2=INDEX(_xlws.SORT(UNIQUE(Data!$A$2:$A$11)),ROWS($A$2:A2))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Claude in Sheets Opus 5.5 · Medium

Passed27s · 11¢
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORTN(SORT(FILTER(Data!A2:C1000, LEN(Data!A2:A1000)), 1, TRUE, 2, FALSE), 9^9, 2, 1, TRUE)"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Claude Code + Sheets MCP Opus 5.5 · Medium

Passed28s · N/A
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(SORTN(SORT(FILTER(Data!A2:C1000,Data!A2:A1000<>""""),2,FALSE),9^9,2,1,TRUE),1,TRUE)"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Autosheet in Excel GPT-6.1 Sol · Medium

Passed23s · 4¢
Report15 cells changed

A2=LET(_xlpm.records,SORTBY(Data!A2:C11,Data!A2:A11,1,Data!B2:B11,-1,ROW(Data!A2:A11),-1),_xlpm.products,INDEX(_xlpm.records,0,1),_xlws.FILTER(_xlpm.records,XMATCH(_xlpm.products,_xlpm.products)=SEQUENCE(ROWS(_xlpm.records))))

ABC
1ProductDateRevenue
2Alpha2025-03-058,300.00
3Beta2025-03-076,450.00
4Delta2025-03-099,400.00
5Gamma2025-03-087,500.00

Claude Code + Autosheet MCP Opus 5.5 · Medium

Passed1m 5s · N/A
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("ARRAYFORMULA(LET(src, FILTER(Data!A2:C1000, TRIM(Data!A2:A1000)<>""""), prod, PROPER(TRIM(INDEX(src,,1))), dt, MAP(INDEX(src,,2), LAMBDA(x, IF(ISNUMBER(x), x, IFERROR(DATEVALUE(TRIM(x)), 0)))), rev, INDEX(src,,3), rowNum, SEQUENCE(ROWS(src)), sorted, SORT"&"(HSTACK(prod, dt, rev, rowNum), 1, TRUE, 2, FALSE, 4, FALSE), names, UNIQUE(INDEX(sorted,,1)), HSTACK(names, XLOOKUP(names, INDEX(sorted,,1), INDEX(sorted,,2)), XLOOKUP(names, INDEX(sorted,,1), INDEX(sorted,,3)))))"),"Alpha")

ABC
1ProductLatest DateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

ChatGPT + Autosheet MCP GPT-6 · Medium

Passed40s · N/A
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(SORTN(SORT(FILTER(Data!A2:C1000, Data!A2:A1000<>""""), 2, FALSE), 9^9, 2, 1, TRUE), 1, TRUE)"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Autosheet in Sheets Haiku 5.5 · High

Passed1m 24s · 0.9¢
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("LET(s, SORT(Data!A2:C11, 1, TRUE, 2, FALSE), FILTER(s, MATCH(INDEX(s,,1), INDEX(s,,1), 0) = SEQUENCE(ROWS(s))))"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

ChatGPT in Excel GPT-6 Astra · Medium

Passed32s · 48¢
Report15 cells changed

A2=LET(_xlpm.records,SORTBY(Data!A2:C11,Data!B2:B11,-1),_xlpm.products,INDEX(_xlpm.records,0,1),_xlws.SORT(_xlws.FILTER(_xlpm.records,XMATCH(_xlpm.products,_xlpm.products)=SEQUENCE(ROWS(_xlpm.records))),1,1))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Claude in Excel Haiku 5.5 · High

Passed31s · 0.9¢
Report15 cells changed

A2=LET(_xlpm.prod,Data!$A$2:$A$11,_xlpm.dt,DATEVALUE(Data!$B$2:$B$11),_xlpm.rev,Data!$C$2:$C$11,_xlpm.u,_xlws.SORT(UNIQUE(_xlpm.prod)),_xlpm.ld,MAP(_xlpm.u,LAMBDA(_xlpm.p,MAX(IF(_xlpm.prod=_xlpm.p,_xlpm.dt)))),_xlpm.idx,MAP(_xlpm.u,_xlpm.ld,LAMBDA(_xlpm.p,_xlpm.d,XMATCH(1,(_xlpm.prod=_xlpm.p)*(_xlpm.dt=_xlpm.d)))),HSTACK(_xlpm.u,INDEX(Data!$B$2:$B$11,_xlpm.idx),INDEX(_xlpm.rev,_xlpm.idx)))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Claude in Sheets Haiku 5.5 · High

Passed26s · 0.6¢
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("ARRAYFORMULA(LET(d,FILTER(Data!A2:C1000,Data!A2:A1000<>""""),s,SORT(d,2,FALSE),p,UNIQUE(INDEX(d,,1)),r,MATCH(p,INDEX(s,,1),0),SORT(CHOOSEROWS(s,r),1,TRUE)))"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Autosheet in Excel GPT-6 Luna · High

Passed29s · 0.5¢
Report15 cells changed

A2=LET(_xlpm.products,_xlws.SORT(UNIQUE(_xlws.FILTER(Data!A2:A11,Data!A2:A11<>""))),_xlpm.productNames,Data!A2:A11,_xlpm.dates,Data!B2:B11,_xlpm.revenue,Data!C2:C11,_xlpm.latestDates,MAP(_xlpm.products,LAMBDA(_xlpm.product,INDEX(_xlws.SORT(_xlws.FILTER(_xlpm.dates,_xlpm.productNames=_xlpm.product),1,-1),1))),_xlpm.latestRevenue,MAP(_xlpm.products,_xlpm.latestDates,LAMBDA(_xlpm.product,_xlpm.latestDate,XLOOKUP(1,(_xlpm.productNames=_xlpm.product)*(_xlpm.dates=_xlpm.latestDate),_xlpm.revenue))),HSTACK(_xlpm.products,_xlpm.latestDates,_xlpm.latestRevenue))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Copilot in Excel Auto

Passed32s · N/A
Report15 cells changed

A2=LET(_xlpm.p,Data!A2:A11,_xlpm.d,Data!B2:B11,_xlpm.r,Data!C2:C11,_xlpm.dn,IF(ISNUMBER(_xlpm.d),_xlpm.d,DATEVALUE(_xlpm.d)),_xlpm.u,_xlws.SORT(UNIQUE(_xlws.FILTER(_xlpm.p,_xlpm.p<>""))),_xlpm.md,MAP(_xlpm.u,LAMBDA(_xlpm.x,MAX(_xlws.FILTER(_xlpm.dn,_xlpm.p=_xlpm.x)))),HSTACK(_xlpm.u,_xlpm.md,MAP(_xlpm.u,_xlpm.md,LAMBDA(_xlpm.x,_xlpm.y,XLOOKUP(1,(_xlpm.p=_xlpm.x)*(_xlpm.dn=_xlpm.y),_xlpm.r)))))

ABC
1ProductDateRevenue
2Alpha2025-03-058,300
3Beta2025-03-076,450
4Delta2025-03-099,400
5Gamma2025-03-087,500

ChatGPT + Drive MCP GPT-6 · Medium

Passed38s · N/A
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(SORTN(SORT(FILTER(Data!A2:C1000,Data!A2:A1000<>""""),2,FALSE),9^9,2,1,TRUE),1,TRUE)"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

ChatGPT in Excel GPT-6 Luna · High

Passed41s · 0.6¢
Report15 cells changed

A2=LET(_xlpm.d,_xlws.FILTER(Data!A2:C1000,Data!A2:A1000<>""),_xlpm.s,SORTBY(_xlpm.d,CHOOSECOLS(_xlpm.d,2),-1),_xlpm.p,_xlws.SORT(UNIQUE(CHOOSECOLS(_xlpm.d,1))),HSTACK(_xlpm.p,XLOOKUP(_xlpm.p,CHOOSECOLS(_xlpm.s,1),CHOOSECOLS(_xlpm.s,2)),XLOOKUP(_xlpm.p,CHOOSECOLS(_xlpm.s,1),CHOOSECOLS(_xlpm.s,3))))

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

Gemini in Sheets Auto

Passed3m · N/A
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORTN(SORT(FILTER(Data!A2:C1000, Data!A2:A1000<>""""), 2, FALSE), 9^9, 2, 1, TRUE)"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058,300
3Beta2025-03-076,450
4Delta2025-03-099,400
5Gamma2025-03-087,500

ChatGPT in Sheets GPT-6 Astra · Medium

Passed1m 53s · 66¢
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(FILTER(Data!A2:C11,MMULT((Data!A2:A11=TRANSPOSE(Data!A2:A11))*(Data!B2:B11<TRANSPOSE(Data!B2:B11)),ROW(Data!A2:A11)^0)=0),1,1)"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500

ChatGPT in Sheets GPT-6 Luna · High

Passed5m · 3¢
Report15 cells changed

A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(UNIQUE(FILTER(Data!A2:A1000,Data!A2:A1000<>"""")))"),"Alpha")

ABC
1ProductDateRevenue
2Alpha2025-03-058300
3Beta2025-03-076450
4Delta2025-03-099400
5Gamma2025-03-087500