How do I do a cost comparison of products from many vendors?
 

I have a list of about 50 different products that I want to compare different
vendor's costs. There are about five vendors total.

How do I do a cost comparison of products from many vendors?
 

How do you do the comparison manually? We need that to arrive at an
automated solution.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"rolson" wrote in message
...
I have a list of about 50 different products that I want to compare
different
vendor's costs. There are about five vendors total.

How do I do a cost comparison of products from many vendors?
 

Don't laugh. I write all of my lists on a yellow tablet with the supplies on
the left column and the different vendors across the top. My question may
have been more basic than you thought; I just want to transfer my handwritten
list to a managable printed list. It would also be nice if it would do an
automated comparison, but that may be too advanced for me. Thank you for
your time.

"Bob Phillips" wrote:

How do you do the comparison manually? We need that to arrive at an
automated solution.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"rolson" wrote in message
...
I have a list of about 50 different products that I want to compare
different
vendor's costs. There are about five vendors total.

How do I do a cost comparison of products from many vendors?
 

Hi

If you enter your suppliers in B1 to F1 , and enter your Products in
A2:A51
Fill in Prices as appropriate
In cell G2 enter
=MIN($B2:$F2)
in Cell H2 enter
=INDEX($B$1:$F$1,MATCH(G2,$B2:$F2,0))

Select cells G2:H2 and copy the formulae down through cells G3:G51

You will now have the Lowest Price on each row in G and the Name of the
supplier in cell H .

--
Regards

Roger Govier


"rolson" wrote in message
...
Don't laugh. I write all of my lists on a yellow tablet with the
supplies on
the left column and the different vendors across the top. My question
may
have been more basic than you thought; I just want to transfer my
handwritten
list to a managable printed list. It would also be nice if it would
do an
automated comparison, but that may be too advanced for me. Thank you
for
your time.

"Bob Phillips" wrote:

How do you do the comparison manually? We need that to arrive at an
automated solution.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"rolson" wrote in message
...
I have a list of about 50 different products that I want to compare
different
vendor's costs. There are about five vendors total.

Hello rolson do you have some good galaxy tablet offers? I need two.