if two cells are equal?
 

From three cells I can make excel find the lowest "bid" for a job. But it
does not tell me if two or more bids are identical? how can I solve this
problem?

You could use conditional formatting, by selecting all of the cells, and use
a formula of =MIN($A$1:$M$1) say. Then all values will show.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Clagge" wrote in message
...
From three cells I can make excel find the lowest "bid" for a job. But it
does not tell me if two or more bids are identical? how can I solve this
problem?

And think you could also try in say, N1:

=IF(COUNTIF(A$1:M$1,MIN(A$1:M$1))1,"More than 1 lowest bid",MIN(A$1:M$1))

which will return the alert: "More than 1 lowest bid" if there are ties
It'll just return the lowest bid figure if there are no ties

Copy N1 down for other rows, if needed.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----