Combining the If and Max function

Closed
tempest32 - Feb 3, 2010 at 01:46 PM
rizvisa1
Posts
4479
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

1 reply

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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