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

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
 
S

Stefi

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top