View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GerryK
 
Posts: n/a
Default 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