How do I display the max(A1:A4) value on to a different column (A6:A9)?

[arthurz11]

SAMPLE:
The maximum value in column (A1:A4) is 700
A1 =100
A2 =700
A3 =100
A4 =100

I want to display the maximum value in a different column (A6:A9)

A6 =blank
A7 =700
A8 =blank
A9 =blank

How do I write the formula in cells A6 thru A9? Please help.

 

[Max1616]

Perhaps try this in cells A6, and copy the formula down to A9:

=IF(MAX($A$1:$A$4)=A1,A1,"")

 

[arthurz11]

Perhaps try this in cells A6, and copy the formula down to A9:

=IF(MAX($A$1:$A$4)=A1,A1,"")

You're the Man, the Myth, and the Legend!! The formula worked. Thank you so much!

 

[Peter_SSs]

If you are interested, with your Excel version, you could use this adaptation in A5 and you don't need to drag it down

=IF(MAX($A$1:$A$4)=A1:A4,A1:A4,"")

 

[arthurz11]

If you are interested, with your Excel version, you could use this adaptation in A5 and you don't need to drag it down

=IF(MAX($A$1:$A$4)=A1:A4,A1:A4,"")

Thanks!