hi there,
im trying to find the range of some figures. I've been doing this using max-min as I'm unaware if there is a function that will do this for me. How would I go about finding the range of a set of figures but exclude any "zero" values?
I tried to use the "countif" function however was unable to figure out how to use this in combination with the max-min formula.
Any help would be great
thanks
Bookmarks