*HELP* Need a cell to return a column heading
Hello - I am in need of a formula to return the value from a column
heading. A B C MAX REF 1 0 3 3 1 2 1 2 0 0 0 0 3 0 1 3 2 0 3 3 2 0 3 3 1 0 2 2 0 2 0 2 1 0 2 2 In the REF column, I would like to lookup the value from the MAX column and return the correct column heading. So for example, the first REF cell would find the number 3 and return the answer C. The second cell down would find the number 2 and return the value B. Thanks for any assistance someone can provide! Dan |
*HELP* Need a cell to return a column heading
=IF(MAX(A2:C2)<0,LEFT(ADDRESS(1,MAX(A2:C2),2)),"" )
assumes columns are A-Z only! "dan" wrote: Hello - I am in need of a formula to return the value from a column heading. A B C MAX REF 1 0 3 3 1 2 1 2 0 0 0 0 3 0 1 3 2 0 3 3 2 0 3 3 1 0 2 2 0 2 0 2 1 0 2 2 In the REF column, I would like to lookup the value from the MAX column and return the correct column heading. So for example, the first REF cell would find the number 3 and return the answer C. The second cell down would find the number 2 and return the value B. Thanks for any assistance someone can provide! Dan |
*HELP* Need a cell to return a column heading
Assuming that A, B and C are real headers that you put there and not the
built in column headers =INDEX($A$1:$D$1,MATCH(D2,$A2:$C2,0)) copy down this assumes you A is in A1 and the first data starts in A2 if there is more than one value that matches it will return the first occurrence -- Regards, Peo Sjoblom "dan" wrote in message ps.com... Hello - I am in need of a formula to return the value from a column heading. A B C MAX REF 1 0 3 3 1 2 1 2 0 0 0 0 3 0 1 3 2 0 3 3 2 0 3 3 1 0 2 2 0 2 0 2 1 0 2 2 In the REF column, I would like to lookup the value from the MAX column and return the correct column heading. So for example, the first REF cell would find the number 3 and return the answer C. The second cell down would find the number 2 and return the value B. Thanks for any assistance someone can provide! Dan |
*HELP* Need a cell to return a column heading
Maybe another way:
=IF(OR(D1={"",0}),"",MID(ADDRESS(1,MATCH(D1,A1:C1) ),2,1)) HTH, Paul -- "dan" wrote in message ps.com... Hello - I am in need of a formula to return the value from a column heading. A B C MAX REF 1 0 3 3 1 2 1 2 0 0 0 0 3 0 1 3 2 0 3 3 2 0 3 3 1 0 2 2 0 2 0 2 1 0 2 2 In the REF column, I would like to lookup the value from the MAX column and return the correct column heading. So for example, the first REF cell would find the number 3 and return the answer C. The second cell down would find the number 2 and return the value B. Thanks for any assistance someone can provide! Dan |
*HELP* Need a cell to return a column heading
On Aug 15, 12:12 pm, "Peo Sjoblom" wrote:
Assuming that A, B and C are real headers that you put there and not the built in column headers =INDEX($A$1:$D$1,MATCH(D2,$A2:$C2,0)) copy down this assumes you A is in A1 and the first data starts in A2 if there is more than one value that matches it will return the first occurrence -- Regards, Peo Sjoblom "dan" wrote in message ps.com... Hello - I am in need of a formula to return the value from a column heading. A B C MAX REF 1 0 3 3 1 2 1 2 0 0 0 0 3 0 1 3 2 0 3 3 2 0 3 3 1 0 2 2 0 2 0 2 1 0 2 2 In the REF column, I would like to lookup the value from the MAX column and return the correct column heading. So for example, the first REF cell would find the number 3 and return the answer C. The second cell down would find the number 2 and return the value B. Thanks for any assistance someone can provide! Dan- Hide quoted text - - Show quoted text - Thank you so much!! Dan |
All times are GMT +1. The time now is 11:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com