if two cells are equal?

[Clagge]

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?

 

[Bob Phillips]

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)

 

[Max]

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.