Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10,593
Default 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.



  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default 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.




  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,886
Default 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.






  #5   Report Post  
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by rolson View Post
I have a list of about 50 different tablet pc 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.

Last edited by DarrellPayne : April 9th 13 at 05:50 AM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cost comparison report Julia Charts and Charting in Excel 1 September 12th 06 05:00 AM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Indexing a row ecohen1 Excel Worksheet Functions 6 July 20th 05 06:11 PM
our cost to customers cost thisguy Excel Worksheet Functions 2 July 15th 05 03:38 AM


All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"