Thank you sandy666..... what im looking for is to compare the one score from judge1 B7 with the other 4 Judges B7s; compare if Judge 1, on B7 is the highest or lowest between the rest of the judges ( Judge 2,B7, Judge 3,B7, Judge 4,B7, Judge 5,B7 ) if Judge 1, B7 Is the highest return "HIGH", if Judge 1, B7 Is the min return "LOW", then only C7s etc... then only B8s, C8s etc...
I do have the desire result with this formula showing here but the returned text value, either "HIGH", "LOW" or "On Range" is not recognized when is referenced on a formula to be returned with IF statement
(IF(REF="HIGH","HIGH"),IF(REF='LOW","LOW","On Range))
To solved it i gave a value of "0" to "On Range" a value of "1" to "LOW" and a value of 3 to "HIGH"
20 of these for B7:U7 nested per color
To retrieve desire value i added a help cell:
and then finally
(IF(REF=1,"LOW",IF REF=3,"HIGH",'On Range"))
Your codes and suggestions helped a lot to solve my thread, thank you very much for your time and help!!
Bookmarks