|Subject:||Finding the lowest number|
|Posted by:||Barney (barney…@bellsouth.net)|
|Date:||Tue, 3 Mar 2009|
In cell A4, I want to check cell A3, to see if it is the sole lowest number
in a set of numbers. The set is not a range but rather individual cells like
A3, A5, A7, A9, A11, A13 etc. If the number (A3) is the lowest and has no
others equal to it in the set, then I want to put the number 1 in cell A4.
What is the formula for cell A4?