Determine lowest number

  • Thread starter Thread starter Barney
  • Start date Start date
B

Barney

I want to determine if a number is the lowest number and not equal to any
other number in a column of numbers.

What is the simplest way to do that with a formula?

Thanks,

Barney
 
Not clear with your question.
Do you pick a number to determine if it's present *and* the lowest?
Do you wish to *find* the lowest number? ... And then see if it's
duplicated?

Data list in A1:A20

In B1, find smallest number:
=MIN(A1:A20)

In C1, how many of them are there:
=COUNTIF(A1:A20,B1)

OR
In B1, enter a number to find, and the formula in C1 will return how many,
if any, are present in A1:A20.
AND
To determine if it's the lowest,
In D1, enter:
=MIN(A1:A20)=B1
For a "True" or "False" return.

If this does not answer your question, post back with more explicit
information.
 
Example:

A B
1 3 4
2 4 4
3 4 5
4 3 3
5 5 6
6 6 5

7 " " Result of formula in A7 (=IF(A1 min A1:A6 AND not duplicated,
then "1", else " ".
8 1 Result of formula in B8 (=If(B1 min B1:B6 AND not duplicated,
then "1", else " ".

Barney
 
Hi
one way:
=IF(AND(A1=MIN(A1:A10),COUNTIF(A1:A10,A1)=1),"Minimum without duplicate","")
 
This does *exactly* what you ask.
Which means if A1 *IS* the lowest, ... *BUT* ... it's duplicated, you will
get the *same* return as if it *was not* the lowest !

=IF(AND(A1=MIN(A1:A20),COUNTIF(A1:A20,A1)=1),1,"")
 
Back
Top