=MAX(SUBTOTAL(9,OFFSET(B1,ROW(1:21),,3)))
How about a little more detail. What exactly do you want? How do you know
you even want this formula? Tell us what you are trying to calculate, please.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"unknown" wrote:
|