if two cells are equal?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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.
 
Back
Top