Header Row Cell Text

P

perplexed

I am using the array formula {=MIN(IF(A1:A10>0,A1:A10))} to find the minimum
bid from a supplier in a large (80 columns x 300 row) spreadsheet and want to
find the column header text (Supplier Name) for the minimum value.
 
B

Bernard Liengme

You need to use Match and Index but please tell us:
If the data is in 80 columns by 300 rows, why are you looking at only 10
rows.
Let us know the actual layout.
I suspect row 1 has supplier names
Is each subsequent row a lists of bids on a particular item (named in column
A)?
=MIN(IF(B2:CB2>0,B2:CB2)) will give the minimum non-zero bid in row 2

I will show example with 6 suppliers (B1:G1)
Minimum {=MIN(IF(B25:G25>0,B25:G25))} in I2
Supplier =INDEX($B$1:$G$1,1,MATCH(I2,B2:G2))

best wishes
 
P

perplexed

The formula was a format example only. The data actually starts in column F
with the part information to the left of that and supplier names as the
header text. I will try the suggested formula. Thanks.
 
P

perplexed

I tried the formula =INDEX($F$1:$AQ$1,1,MATCH(AR2,F2:AQ2)) where:
F is the first column of entered data
AQ is the last column of entered data
AR is the stored result of the MIN array
Row 1 is the supplier names (alternating with an extension column for each
entry)

The results are responding with header text, but from the wrong columns.
 
B

Bernard Liengme

In a hurry ..but try
I tried the formula =INDEX($F$2:$AQ$1,1,MATCH(AR2,F2:AQ2)) where
 

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