identifying text associated with MIN value

V

vanessa

I am trying to analyze a spreadsheet of company bids and need some help. The
spreasheet is organized by store (down column A) and by company across the
top. With help from this board I figured out how to find the MIN bid value.
However, I would like to associate this value with the company that bid that
amount. Is there any way to do this in Excel?
 
M

Max

Assume company names in B1:D1,
with associated bids per row item in B2:D2 down
Put in say, F2: =INDEX(B$1:D$1,MATCH(MIN(B2:D2),B2:D2,0))
Copy F2 down to return the company which bid the min per row item. Adapt to
suit. In the event of a tie in the min bid, the leftmost company will be
returned
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
 
V

vanessa

Thanks Max, but this is not working quite right for me. It keeps giving me
the company name associated with zero value bids. Any adivce on how to get
Excel to ignore the zeros?
 
T

T. Valko

Based on Max's setup.

Assumes there is at least 1 non-zero number in the row.

=INDEX(B$1:D$1,MATCH(SMALL(B2:D2,COUNTIF(B2:D2,0)+1),B2:D2,0))
 
V

vanessa

That works. Thank you!

T. Valko said:
Based on Max's setup.

Assumes there is at least 1 non-zero number in the row.

=INDEX(B$1:D$1,MATCH(SMALL(B2:D2,COUNTIF(B2:D2,0)+1),B2:D2,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top