View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] bijuthomas73@gmail.com is offline
external usenet poster
 
Posts: 1
Default Column header for Max value? Index/array function?

On Thursday, December 3, 2009 3:33:01 AM UTC+4, Cecilia wrote:
Hello--

I have a series of columns for which I'm trying to find the column header
for the max value. For example:

A B C D E F
Store 1 Store 2 Store 3 Store 4
Row 1 1 9 60 72 Store 4
Row 2 16 33 20 25 Store 2
Row 3 26 18 68 79 Store 4

I'm trying to find a formula that looks for the maximum value across a range
of columns and then returns the corresponding column header for that column.
The result I'm looking for is in column F.

Hoping someone can help.

Thanks!!

Cecilia


thanks