Identifying if a Value is the MAX in a data series

  • Thread starter Thread starter carlos
  • Start date Start date
C

carlos

Hi. I have the following data:
A B C D E F G
Row1 0.6 0.6 0.6 0.55 0.6 0.6
Row2 0.7 0.7 0.7 0.7 0.7 0.7
Row3 0.6 0.6 0.6 0.55 0.6 0.6

I would like to write a formula in column G that will
look at the value in column A and return "BEST" if the
value is greater than the values in column B,C,D,E,F.

Thank you in advance for your assistance.
 
Hi Carlos

try
=if(A1>Max(B1:F1),"BEST","")

so in all of your examples "BEST" would not be returned as the values in A
are equal to the Max values from the other columns.

Cheers
JulieD
 
Need to be careful seeing that A1 = B1 & C1 in his example data. Might want to
caveat that with an = sign as well:-

=IF(A1=>MAX(B1:F1),"BEST","")

OP should have clarified though :-)
 
And I guess I should try reading the question more than once, as I had
interpreted it as he just wanted to know if he had a value = the 'Best' value in
Col A. Looking at it again, that intepretation was very likely totally
incorrect :-(
 
Ken said:
And I guess I should try reading the question more than once, as I had
interpreted it as he just wanted to know if he had a value = the
'Best' value in Col A. Looking at it again, that intepretation was
very likely totally incorrect :-(
Click to expand...

Ken
maybe more coffee is required <vbg>

wish you a nice weekend
Frank
 
LOL - It's OK for you Frank, I don't have a Starbucks next door, and i just
can't seem to make it taste the same :-)
 
Back
Top