If Then?

P

picktr

I need an equation to take a range of cells, evaluate
which cell has the lowest number, and return a
a value of 1.

AND

If more than one cell have the same number,
assign a value that is ( 1.00 / number of cells with same number)

Else 0

ex 3 cells have the same number, result is 0.333


Thank You!

Tom [email protected]
 
A

AlfD

Hi!

You might get subtle solutions, but as a starter, here's a very basi
one.

Assume data is in col A from 2 to 20.
In B1 enter =small(A2:A20,1)
In B2 enter =if(A2=$B$1,1,0)
Copy this down to B20
In B21 enter =sum(B2:B20)
In C2 enter = if(B2=1,1/$B$21,"")
Copy down to C20.
Format this column to as many d.p.s as you want/need.
Hide column B

Al
 
R

Ron Rosenfeld

I need an equation to take a range of cells, evaluate
which cell has the lowest number, and return a
a value of 1.

AND

If more than one cell have the same number,
assign a value that is ( 1.00 / number of cells with same number)

Else 0

ex 3 cells have the same number, result is 0.333


Thank You!

Tom [email protected]
Click to expand...

How about:

=1/COUNTIF(rng,MIN(rng))


--ron
 
Top