Compare Cells of Text and Return Highest Value based on a Customiz

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

Similar to the MAX function where it compares several cells of number and
returns the highest value, it is possible to compare several cells of text
and return the highest value based on a customized list.
For example the customized list could be: Critical, High, Moderate and lower
Col A Col B Col C Col with formula to return highest value of Col A, B, C
Crit High Low Crit
Low Mod Low Mod
Low Mod High High

Thanks,
Rod
 
Enter

=LOOKUP(MAX(LOOKUP(A2:C2,{"Crit","High","Low","Mod"},{4,3,1,2})),{1,2,3,4},{"Low","Mod","High","Crit"})

in cell D2 as an array formula confirmed with Ctrl+Shift+Enter and drag it
down!

Regards,
Stefi

„Rod†ezt írta:
 
Back
Top