Header Row Cell Text
 

I am using the array formula {=MIN(IF(A1:A100,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.

Header Row Cell Text
 

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:CB20,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:G250,B25:G25))} in I2
Supplier =INDEX($B$1:$G$1,1,MATCH(I2,B2:G2))

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"perplexed" wrote in message
...
I am using the array formula {=MIN(IF(A1:A100,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.

Header Row Cell Text
 

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.

"Bernard Liengme" wrote:

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:CB20,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:G250,B25:G25))} in I2
Supplier =INDEX($B$1:$G$1,1,MATCH(I2,B2:G2))

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"perplexed" wrote in message
...
I am using the array formula {=MIN(IF(A1:A100,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.

Header Row Cell Text
 

I tried the formula =INDEX($F$1:$AQ$1,1,MATCH(AR2,F2:AQ2)) whe
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.

"perplexed" wrote:

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.

"Bernard Liengme" wrote:

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:CB20,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:G250,B25:G25))} in I2
Supplier =INDEX($B$1:$G$1,1,MATCH(I2,B2:G2))

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"perplexed" wrote in message
...
I am using the array formula {=MIN(IF(A1:A100,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.

Header Row Cell Text
 

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"perplexed" wrote in message
...
I tried the formula =INDEX($F$1:$AQ$1,1,MATCH(AR2,F2:AQ2)) whe
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.

"perplexed" wrote:

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.

"Bernard Liengme" wrote:

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:CB20,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:G250,B25:G25))} in I2
Supplier =INDEX($B$1:$G$1,1,MATCH(I2,B2:G2))

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"perplexed" wrote in message
...
I am using the array formula {=MIN(IF(A1:A100,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.