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

Similar Threads

Compare Cells of Text and Return Highest Value based on a Customiz 0
Compare two cells in two different files and return answer 6
Remove all duplicates and return highest value in new row 6
finding is a value is betwen a range of values 5
how to find text vaues for a given grade? 0
Database questions, giving text a numerical value 2
Calculating a peak value in a range of cells 1
Word macro that can call cells out of Excel for a find and replace 0

Top