"Aladin Akyurek" wrote:


bj wrote:
If you start out in row 3 (for example) change it to

=large($P$4:$P$65536,row()-2)

[...]

What is going to happen if some rows are inserted before the formula row?

The equation would have to be modified
one way to do it would be to name a range equal to the first equation cell
[initr = $C$3]
change the equation to
=large($P$4:$P$65536,row()-row(initr)+1)