cell in row has highest value and rtrns col hdr

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

hi,
can anyone advise as to which formula would be able to find the highest
("=MAX(A$:T$)")value in a row of cells and once identified return the column
header? thanks for any help!
 
=index(1:1,match(max(2:2),2:2,0))

Will find the first largest value in row 2 and return the header from row 1.
 
Michael said:
hi,
can anyone advise as to which formula would be able to find the highest
("=MAX(A$:T$)")value in a row of cells and once identified return the column
header? thanks for any help!
Click to expand...
Michael

=INDIRECT(ADDRESS(1,MATCH(MAX(A2:T2),A2:T2,0)))&",
"&INDIRECT(ADDRESS(1,MATCH(MAX(A2:T2),A2:T2,1)))

gives you up to two headers, assuming that a number may be duplicated. MAke
sure the whole formula is pasted in one line in U2 and copy it down

Regards
Peter
 
On second thoughts it doesn't work try

=INDIRECT(ADDRESS(1,MATCH(MAX(A4:F4),A4:F4,0)))

which will just give you the first header if the max is duplicated.

Peter
 
Ah well, at last one for two maxs in row if you need it

=IF(COUNTIF(A4:t4,MAX(A4:t4))>1,INDIRECT(ADDRESS(1,MATCH(MAX(A6:t6),A6:t6,0)))&",
"&INDIRECT(ADDRESS(1,MATCH(MAX(A6:t6),A6:t6,1))),INDIRECT(ADDRESS(1,MATCH(MAX(A5:t5),A5:Ft,0))))

paste to u 4 and copy

Peter
 
Dave,
Thank you very much for your response. If there is more than 1 cell that
has is equal to the "highest" value, will this also display the subsequent
col. hdrs?
 
Nope. It just displays the first match.
Dave,
Thank you very much for your response. If there is more than 1 cell that
has is equal to the "highest" value, will this also display the subsequent
col. hdrs?
Click to expand...
 
Dave,
thanks again for your attention and response to what is a lack of my ability
to figure this out. Can you offer a solution for this?
 
Maybe you can use one of the lookup formulas on Chip Pearson's page.

I'd look at the arbitrary lookup section.
Dave,
thanks again for your attention and response to what is a lack of my ability
to figure this out. Can you offer a solution for this?
Click to expand...
 
Dave,
I hate to be the reason the folks with your talent might become "unnerved"
with involving yourself providing direction and knowledge to one, myself, a
dribbling idiot, which now has to ask you...how does one find Chip Pearson's
page? Thanks again...100 thanks for your patience!!
Michael
 
Oopsie...

http://cpearson.com/excel/lookups.htm

But if you use google to search the *excel* newsgroups, you would have found
thousands of hits to Chip's site. It's quite popular. You may want to bookmark
it for other stuff.
Dave,
I hate to be the reason the folks with your talent might become "unnerved"
with involving yourself providing direction and knowledge to one, myself, a
dribbling idiot, which now has to ask you...how does one find Chip Pearson's
page? Thanks again...100 thanks for your patience!!
Michael
Click to expand...
 
Dave,
Many thanks!! This one is a bit over my head. I'll give myself a week to
play with this and see if I eventually grasp.
Thank you.
Michael R
 

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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Find largest value in column with 2 criteria 1
Retrieving the date in a MAX column 5
is Retrieving a Cell address from a cell containing a SUMPRODUCTformula a problem ? 5
Finding location (or start cell) of highest consecutive values 3
Which Function does.... 7
Compare Cells of Text and Return Highest Value based on a Customiz 1
Help with Finding Highest value 3

Back
Top