Searching for a formula to select the highest value

I need help creating a formula in Excel, as I have four values in the left column (Minor, Moderate, Major, Extreme) and on the right column, it should show in the cell of the highest value from the l...

excel

Formulas and Functions

OliverScheurich

Jul 21, 2023

talotaibi

=IF(COUNTIF(I2:I5,"extreme"),"extreme",IF(COUNTIF(I2:I5,"major"),"major",IF(COUNTIF(I2:I5,"moderate"),"moderate",IF(COUNTIF(I2:I5,"minor"),"minor",""))))

Does this return the intended result?

OliverScheurich

Gold Contributor

Jul 21, 2023

talotaibi

=IF(COUNTIF(I2:I5,"extreme"),"extreme",IF(COUNTIF(I2:I5,"major"),"major",IF(COUNTIF(I2:I5,"moderate"),"moderate",IF(COUNTIF(I2:I5,"minor"),"minor",""))))

Does this return the intended result?

talotaibi

Copper Contributor

Jul 21, 2023

Yes, its work.
Thanks a lot

Forum Discussion

Searching for a formula to select the highest value

Resources