|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
=MAX(SUBTOTAL(9,OFFSET(B1,ROW(1:21),,3)))
Martin Roland wrote:
=MAX(SUBTOTAL(9,OFFSET(B1,ROW(1:21),,3)))
I am trying to do this exact same formula, however, I need my array to calculate across columns instead of rows, I have substituted ROW with COLUMN but I get 0.00's. Any advice?
See if this thread helps:
http://tinyurl.com/2bczrdt
|