View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
virtualjustin virtualjustin is offline
external usenet poster
 
Posts: 1
Default How get Excel 2007 to return highest column

I have an array of data. I need a formula that will return the column number
of the highest column with content.


For example:
A B C D E F
1 3 2 3
2 3 4
3 2 4 5 1
4 2 3

Where the answers should be D, E, F, and B, respectively.

Any suggestions?
Thanks
Justin