Finding the lowest number

Giganews Newsgroups
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?

Thanks,

Barney

Replies