Hi,
Not sure about this...
Assume your data in A1:J10
In L1:
=MAX(A1:J10)
In L2 and copied down,
=MAX(IF($A$1:$J$10<L1,$A$1:$J$10))
It's an array formula.
Hi,
Not sure about this...
Assume your data in A1:J10
In L1:
=MAX(A1:J10)
In L2 and copied down,
=MAX(IF($A$1:$J$10<L1,$A$1:$J$10))
It's an array formula.
Bookmarks