ExcelBanter - Sort (parameter stored in cell)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sort (parameter stored in cell) (https://www.excelbanter.com/excel-worksheet-functions/78784-sort-parameter-stored-cell.html)

GerryK

Sort (parameter stored in cell)

Is it possible to have a cell indicate which column was the basis of my sort?

Example:
I have simple text headings in A1 to F1.
I sort on column C.
Is there a way to have H1 return the name from the header row found in C1?

TIA
Gerry

All times are GMT +1. The time now is 06:52 PM.