Sort months in calendar order with a formula
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
On the Report sheet, put the headers in row 1 and use a formula starting in A2 to sort the months from Jan to Dec rather than alphabetically.
Data
Starting sheet| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Apr | 9100 |
| 3 | Jan | 7600 |
| 4 | Mar | 8400 |
| 5 | Feb | 7800 |
| 6 | Jun | 9800 |
| 7 | May | 9500 |
| 8 | Aug | 10200 |
| 9 | Jul | 9950 |
| 10 | Oct | 11000 |
| 11 | Sep | 10750 |
| 12 | Dec | 12100 |
| 13 | Nov | 11850 |
Report
Starting sheet| A | |
|---|---|
| 1 |
Expected result
Pass criteria
All must be met, checked automatically.Report!A1:B13hold the expected valuesReport!A2uses a formula
Passed 22
Autosheet in Excel Opus 5.5 · Medium
A1=Data!A1
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Autosheet in Excel GPT-6 Astra · Low
A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7,600 |
| 3 | Feb | 7,800 |
| 4 | Mar | 8,400 |
| 5 | Apr | 9,100 |
| 6 | May | 9,500 |
| 7 | Jun | 9,800 |
| 8 | Jul | 9,950 |
| 9 | Aug | 10,200 |
| 10 | Sep | 10,750 |
| 11 | Oct | 11,000 |
| 12 | Nov | 11,850 |
| 13 | Dec | 12,100 |
Autosheet in Sheets Opus 5.5 · Medium
A2=SORT(Data!A2:B13, MATCH(Data!A2:A13, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, 0), TRUE)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Autosheet in Excel Sonnet 5.5 · Medium
A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Claude in Excel Opus 5.5 · High
A1=Data!A1
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Autosheet in Excel Haiku 5.5 · High
A2=INDEX(Data!$A$2:$A$13,MATCH(TEXT(DATE(2026,ROWS($A$2:A2),1),"mmm"),Data!$A$2:$A$13,0))
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Claude in Sheets Opus 5.5 · Medium
A1=Data!A1
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Claude Code + Sheets MCP Opus 5.5 · Medium
A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), MATCH(FILTER(Data!A2:A1000, Data!A2:A1000<>""""), {""Jan"";""Feb"";""Mar"";""Apr"";""May"";""Jun"";""Jul"";""Aug"";""Sep"";""Oct"";""Nov"";""Dec""}, 0), TRUE)"),"Jan")
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Autosheet in Excel GPT-6.1 Sol · Medium
A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7,600 |
| 3 | Feb | 7,800 |
| 4 | Mar | 8,400 |
| 5 | Apr | 9,100 |
| 6 | May | 9,500 |
| 7 | Jun | 9,800 |
| 8 | Jul | 9,950 |
| 9 | Aug | 10,200 |
| 10 | Sep | 10,750 |
| 11 | Oct | 11,000 |
| 12 | Nov | 11,850 |
| 13 | Dec | 12,100 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
A2=SORT(Data!A2:B13, MATCH(Data!A2:A13, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, 0), TRUE)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
ChatGPT + Autosheet MCP GPT-6 · Medium
A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(FILTER(Data!A2:B1000, Data!A2:A1000<>""""), MATCH(FILTER(Data!A2:A1000, Data!A2:A1000<>""""), {""Jan"",""Feb"",""Mar"",""Apr"",""May"",""Jun"",""Jul"",""Aug"",""Sep"",""Oct"",""Nov"",""Dec""}, 0), TRUE)"),"Jan")
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Autosheet in Sheets Haiku 5.5 · High
A2=CHOOSECOLS(SORT({Data!A2:B13, MATCH(Data!A2:A13, {"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"}, 0)}, 3, TRUE), 1, 2)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
ChatGPT in Excel GPT-6 Astra · Medium
A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Claude in Excel Haiku 5.5 · High
A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Claude in Sheets Haiku 5.5 · High
A1=Data!A1
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Autosheet in Excel GPT-6 Luna · High
A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Copilot in Excel Auto
A2=SORTBY(Data!A2:B13,MATCH(Data!A2:A13,{"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"},0),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7,600 |
| 3 | Feb | 7,800 |
| 4 | Mar | 8,400 |
| 5 | Apr | 9,100 |
| 6 | May | 9,500 |
| 7 | Jun | 9,800 |
| 8 | Jul | 9,950 |
| 9 | Aug | 10,200 |
| 10 | Sep | 10,750 |
| 11 | Oct | 11,000 |
| 12 | Nov | 11,850 |
| 13 | Dec | 12,100 |
ChatGPT + Drive MCP GPT-6 · Medium
A2=IFERROR(__xludf.DUMMYFUNCTION("SORT(FILTER(Data!A2:B1000,Data!A2:A1000<>""""),ARRAYFORMULA(MATCH(FILTER(Data!A2:A1000,Data!A2:A1000<>""""),{""Jan"";""Feb"";""Mar"";""Apr"";""May"";""Jun"";""Jul"";""Aug"";""Sep"";""Oct"";""Nov"";""Dec""},0)),TRUE)"),"Jan")
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
ChatGPT in Excel GPT-6 Luna · High
A2=SORTBY(Data!A2:B13,MONTH(DATEVALUE("1 "&Data!A2:A13)),1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
Gemini in Sheets Auto
A2=SORT(Data!A2:B13, MONTH(Data!A2:A13&1), 1)
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
ChatGPT in Sheets GPT-6 Astra · Medium
A2=INDEX(Data!A$2:A$13,MATCH(CHOOSE(ROWS($A$2:$A2),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),Data!$A$2:$A$13,0))
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |
ChatGPT in Sheets GPT-6 Luna · High
A2=INDEX(Data!$A$2:$A$13,MATCH(CHOOSE(ROWS($A$2:A2),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"),Data!$A$2:$A$13,0))
| A | B | |
|---|---|---|
| 1 | Month | Revenue |
| 2 | Jan | 7600 |
| 3 | Feb | 7800 |
| 4 | Mar | 8400 |
| 5 | Apr | 9100 |
| 6 | May | 9500 |
| 7 | Jun | 9800 |
| 8 | Jul | 9950 |
| 9 | Aug | 10200 |
| 10 | Sep | 10750 |
| 11 | Oct | 11000 |
| 12 | Nov | 11850 |
| 13 | Dec | 12100 |