Find which column (by its header) holds the largest value in a row.
Copy this formula
=INDEX($B$1:$E$1, MATCH(MAX(B2:E2), B2:E2, 0))MAX finds the largest value in the row, MATCH locates its position, and INDEX returns the matching header from the header row. Swap MAX for MIN to find the smallest instead.
=INDEX($B$1:$E$1, MATCH(MAX(B2:E2), B2:E2, 0))→Q3Q3 was this row's best quarter.
MATCH returns the first match. To list all ties, use a FILTER on the header row instead.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.