MegaSack DRAW - This year's winner is user - rgwb
We will be in touch
Topic starter
I'm looking for a command which will find the minimum, non-zero, absolute value from a set of data.
Such that for the following array: -4 -1 0 2 5 it would return 1.
Any help would be most appreciated.
Posted : 01/12/2010 12:33 pm
Google, wonderful invention:
http://www.exceltip.com/st/Find_the_minimum_positive_value_in_Microsoft_Excel/383.html
Posted : 01/12/2010 12:36 pm
Topic starter
I am aware of the delights of google.
Unfortunately this only considers positive numbers.
Posted : 01/12/2010 1:46 pm
Ricky, use ABS to make the range absolute.
=MIN(IF(ABS(A1:A5)<>0,ABS(A1:A5)))
enter the formula as an array formula (i.e. dont press enter, press Ctrl+Shift+Enter)
Posted : 01/12/2010 1:55 pm