Combining the If and Max function

Closed
tempest32 - Feb 3, 2010 at 01:46 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 3, 2010 at 01:59 PM
Hello,
I have a range of cells that have conditional formatting based on the MAX function. In other words I used the MAX function to find the highest number and then highlight that cell.

Now what I need to do is create a formula that will look at the result of the MAX function and return the column label for that cell location. Since the highlighted cell will change as numbers are calculated so will the column label headings and I need a formula that will change with the results of the MAX function.

An IF function wouldn't work because there are too many arguments and I can't think of what would work for me.

Please help!
Tempest32
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 3, 2010 at 01:59 PM
When things get too messy, I suggest look at creating your own public function and then use that public function to get what you want
0