|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hi,
I have a range of numbers, say, b1:f100.
I want to create an array formula, that delivers an array of maximums for
each row.
This I can easily do by, for example,
{max(offset(b1, row(1:100)-1, 0,1,5))}
If I put this array on a sheet, then I have correct max for each row.
But if I want to select, for example, min of those max I change the
formula to
{min(max(offset(b1, row(1:100)-1, 0,1,5)))}
and it does not work! It reterns the number of rows. Can anyone explain why
and what I have to do to make it work?
Many thank. Sergei
|
|
|