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
---
"vanessa" wrote:
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?