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.
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.