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
Critical High High Critical
Low Mod Mod Mod
High Low Mod High
Thanks,
Rod
 

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 1
Trying to find additional ranges outside of min, max, and average 2
Database questions, giving text a numerical value 2
Word macro that can call cells out of Excel for a find and replace 0
Criteria to return maximum value where x = x 3
formula to compare a values and return 2
Compare two cells in two different files and return answer 6
Find Highest Date in a range 4

Top