Cant get dynamic range formula to work.
Biff,
Forgive me for my blunder. I copied the formula in a partially
modified state. It should be:
=INDEX(P:P,LARGE(IF($P$7:$P$65535<"",ROW($P$7:$P$ 65535)),ROW($AM$17)-ROW()))
I've got it working now.
Thanks,
Mike
|