Header Row Cell Text

[Guest]

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.

 

[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

 

[Guest]

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.

 

[Guest]

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.

 

[Bernard Liengme]

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