software

I am trying to compare prices from various customers to find who have the
lowest prices.Company A Company B Company C
Company DB4 E4 H4
K4 Result
$3.00 $4.00 $2.00 $10.00 company B
I wrote this formula and go this result

=IF(B4gt;K4,IF(B4gt;H4,IF(B4gt;E4,IF(K4gt;B4,IF(K4gt;E4,E4,K 4),H1),B1)),E1)

but it is not giving me the correct answer always, I know i am missing
something but not sure where to add the correct formula. Also if the cell is
blank I want to just disregard the cell. If 2 or more customers have the
same price I want to display that information. I think this is
quot;concatenatequot;.
any help would be appreciated
Use MIN instead: MIN(range_with_values)
In order to know the number of companies with that price, use COUNTIF, to
find the value from the MIN formula in the range with the prices.
--
It is nice to be important, but it is more important to be nicequot;paulquot; wrote:

gt; I am trying to compare prices from various customers to find who have the
gt; lowest prices.
gt;
gt;
gt; Company A Company B Company C
gt; Company D
gt;
gt;
gt; B4 E4 H4
gt; K4 Result
gt; $3.00 $4.00 $2.00 $10.00 company B
gt;
gt;
gt;
gt; I wrote this formula and go this result
gt;
gt; =IF(B4gt;K4,IF(B4gt;H4,IF(B4gt;E4,IF(K4gt;B4,IF(K4gt;E4,E4,K 4),H1),B1)),E1)
gt;
gt; but it is not giving me the correct answer always, I know i am missing
gt; something but not sure where to add the correct formula. Also if the cell is
gt; blank I want to just disregard the cell. If 2 or more customers have the
gt; same price I want to display that information. I think this is
gt; quot;concatenatequot;.
gt; any help would be appreciated
gt;
gt;
gt;

Thank you Miguel
MIN worked I have to work on the countif now.quot;Miguel Zapicoquot; gt; wrote in message
...
gt; Use MIN instead: MIN(range_with_values)
gt; In order to know the number of companies with that price, use COUNTIF, to
gt; find the value from the MIN formula in the range with the prices.
gt; --
gt; It is nice to be important, but it is more important to be nice
gt;
gt;
gt; quot;paulquot; wrote:
gt;
gt;gt; I am trying to compare prices from various customers to find who have the
gt;gt; lowest prices.
gt;gt;
gt;gt;
gt;gt; Company A Company B Company C
gt;gt; Company D
gt;gt;
gt;gt;
gt;gt; B4 E4
gt;gt; H4
gt;gt; K4 Result
gt;gt; $3.00 $4.00 $2.00 $10.00 company B
gt;gt;
gt;gt;
gt;gt;
gt;gt; I wrote this formula and go this result
gt;gt;
gt;gt; =IF(B4gt;K4,IF(B4gt;H4,IF(B4gt;E4,IF(K4gt;B4,IF(K4gt;E4,E4,K 4),H1),B1)),E1)
gt;gt;
gt;gt; but it is not giving me the correct answer always, I know i am missing
gt;gt; something but not sure where to add the correct formula. Also if the cell
gt;gt; is
gt;gt; blank I want to just disregard the cell. If 2 or more customers have the
gt;gt; same price I want to display that information. I think this is
gt;gt; quot;concatenatequot;.
gt;gt; any help would be appreciated
gt;gt;
gt;gt;
gt;gt;
Maybe an example could help. If your data is in A33, and you put the
formula quot;=MIN(A33)quot; in the cell A5, then the formula for the countif should
be quot;=COUNTIF(A33,A5)quot;

--
It is nice to be important, but it is more important to be nicequot;paulquot; wrote:

gt; Thank you Miguel
gt; MIN worked I have to work on the countif now.
gt;
gt;
gt; quot;Miguel Zapicoquot; gt; wrote in message
gt; ...
gt; gt; Use MIN instead: MIN(range_with_values)
gt; gt; In order to know the number of companies with that price, use COUNTIF, to
gt; gt; find the value from the MIN formula in the range with the prices.
gt; gt; --
gt; gt; It is nice to be important, but it is more important to be nice
gt; gt;
gt; gt;
gt; gt; quot;paulquot; wrote:
gt; gt;
gt; gt;gt; I am trying to compare prices from various customers to find who have the
gt; gt;gt; lowest prices.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; Company A Company B Company C
gt; gt;gt; Company D
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; B4 E4
gt; gt;gt; H4
gt; gt;gt; K4 Result
gt; gt;gt; $3.00 $4.00 $2.00 $10.00 company B
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; I wrote this formula and go this result
gt; gt;gt;
gt; gt;gt; =IF(B4gt;K4,IF(B4gt;H4,IF(B4gt;E4,IF(K4gt;B4,IF(K4gt;E4,E4,K 4),H1),B1)),E1)
gt; gt;gt;
gt; gt;gt; but it is not giving me the correct answer always, I know i am missing
gt; gt;gt; something but not sure where to add the correct formula. Also if the cell
gt; gt;gt; is
gt; gt;gt; blank I want to just disregard the cell. If 2 or more customers have the
gt; gt;gt; same price I want to display that information. I think this is
gt; gt;gt; quot;concatenatequot;.
gt; gt;gt; any help would be appreciated
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

See my post in for an approach that takes ties into account:

www.mrexcel.com/board2/viewtopic.php?t=72823paul wrote:
gt; I am trying to compare prices from various customers to find who have the
gt; lowest prices.
gt;
gt;
gt; Company A Company B Company C
gt; Company D
gt;
gt;
gt; B4 E4 H4
gt; K4 Result
gt; $3.00 $4.00 $2.00 $10.00 company B
gt;
gt;
gt;
gt; I wrote this formula and go this result
gt;
gt; =IF(B4gt;K4,IF(B4gt;H4,IF(B4gt;E4,IF(K4gt;B4,IF(K4gt;E4,E4,K 4),H1),B1)),E1)
gt;
gt; but it is not giving me the correct answer always, I know i am missing
gt; something but not sure where to add the correct formula. Also if the cell is
gt; blank I want to just disregard the cell. If 2 or more customers have the
gt; same price I want to display that information. I think this is
gt; quot;concatenatequot;.
gt; any help would be appreciated