Range problem
Luke,
your formula worked like a charm.
thanks,
appreciate it,
Ace
"Mike H" wrote:
Hi,
Try this
=MIN(IF(A1:A80,A1:A8))
This is an array formula which must be entered with CTRL+Shift+Enter and NOT
'just enter. If you do it correctly then Excel will put curly brackets around
'the formula{}. You can't type these yourself. If you Edit the ranges
'then you must re-enter as An array
=Max(a1:a8)
for the max
Mike
"ace" wrote:
Guys,
i have a data set thus,
20
21
21.5
27
24
0
0
19.5
Now the range formula will take 27-0 and give me the answer as 27
but if I want the zeros to be discounted from the range formula is it
possible??
that is i want the range formula to take the max as 27 and in this case the
minimum as 19.5, can it be done??
|