Return the largest number in a range

[dparteka]

This seems somewhat elementary to me but obviously my skill level is not there yet. In cells A1:A5 are numbers, in B1:B5 I’m looking for a formula to look at column A, locate the largest number in that column and duplicate that number into the corresponding B cell. So, if the largest number is 11 in A6 then 11 would also show up in B6 and all other cells would be blank... any help will be greatly appreciated, thank you.

 

[Villalobos]

Hi,

Is this formula help for you?

 

[Shteven]

There are multiple ways to achieve your result. Any of these should work:
=IF(MAX(A$1:A$6)=A1,A1,"")

=IF(LARGE(A$1:A$6,1)=A1,A1,"")

=IF(RANK(A1,A$1:A$6,0)=1,A1,"")

 

[dparteka]

Villalobos & Shteven... excellent, it's like a Greek restaurant in the USA, so many choices. You make it look easy, thank you so much.