Find Highest Value of a Row and make it a 1 If less than highest leave blank.

[Ailg]

Good day, i am attempting to find the highest value from row V12 to V46 and make a 1 in the points field that coincides with the highest number. In the example V21 is the highest and i would like to populate a 1 in the X21 field. If it is not the highest value i would like it to be blank. Thank you.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[Ailg]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Thank you. Updated.

 

[Fluff]

Thanks for that.
how about in X12 only

=IF(MAX(V12:V46)=V12:V46,1,"")

 

[Ailg]

Thanks for that.
how about in X12 only

=IF(MAX(V12:V46)=V12:V46,1,"")

That worked great, however there are several blank cells that now have a 1.

 

[Fluff]

Do you mean in col X?
If so check what is in col V

 

[Ailg]

Do you mean in col X?

If so check what is in col V

In row V, every 3rd line has no data is there a formula that would only indicate a 1 for the highest value in Row V?

 

[Fluff]

How about

=IF((MAX(V12:V46)=V12:V46)*(V12:V46<>""),1,"")

 

[Ailg]

How about

=IF((MAX(V12:V46)=V12:V46)*(V12:V46<>""),1,"")

You are a badass!!! Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback.