Min excluding zero values, without an array fomrula
The only way to be sure is to try it!
--
Biff
Microsoft Excel MVP
"art" wrote in message
...
So what it seems, is that I can't really escape my speed problem. Whatever
I'll do, the alternative would not have any significant speed increase.
Thanks for your input.
Art.
"Gary''s Student" wrote:
You can avoid the array formula if we use some "helper" cells
Say in R99 we enter:
=IF(R2=0,"",R2) and copy across. Then we can simply use:
=MIN(R99:AA99)
--
Gary''s Student - gsnu200854
"art" wrote:
Hello:
I have a formula to calculate the Min value of a range that has
includes
zero values, which the min formula ignors the zero valus. However, it
is an
array function which slows down my spreadsheet, since I have this array
formula on a long list. Is there a way to calculate the min of a range
which
has also some zero values without an array function?
The formula I use now is as follows:
={MIN(IF(R2:AA20,R2:AA2))}
Thanks.
Art
|