Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get text
I am not sure if anybody asked this question and I am sorry if I am repeting
it but i really need help. I made a chart with column A with names and Column B with numbers. Now at the end I am trying to have in Column A the person with the highest number only to be shown. For Example, A B John 12 Sarah 3 Isabel 55 Caroline 33 Highest score has: Isabel Please write in details I tried if and but it gives me #value I am messing a lot somewhere Thank you all so much for you time and help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get text
Try something like this:
With your posted data in A1:B4 This formula returns the name associated with the hight sco =INDEX(A1:A4,MATCH(MAX(B1:B4),B1:B4,0)) Is that something you can work with? *********** Regards, Ron XL2003, WinXP "Bob" wrote: I am not sure if anybody asked this question and I am sorry if I am repeting it but i really need help. I made a chart with column A with names and Column B with numbers. Now at the end I am trying to have in Column A the person with the highest number only to be shown. For Example, A B John 12 Sarah 3 Isabel 55 Caroline 33 Highest score has: Isabel Please write in details I tried if and but it gives me #value I am messing a lot somewhere Thank you all so much for you time and help |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get text
Well you haven't told us what formula you tried, so we can't help you to
debug it, but one that would work is =INDEX(A2:A5,MATCH(MAX(B2:B5),B2:B5)) If your numbers were in the first column and names in the second you could do it more simply with VLOOKUP. -- David Biddulph "Bob" wrote in message ... I am not sure if anybody asked this question and I am sorry if I am repeting it but i really need help. I made a chart with column A with names and Column B with numbers. Now at the end I am trying to have in Column A the person with the highest number only to be shown. For Example, A B John 12 Sarah 3 Isabel 55 Caroline 33 Highest score has: Isabel Please write in details I tried if and but it gives me #value I am messing a lot somewhere Thank you all so much for you time and help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
grab cell text from multi-tab workbook, show text in another workb | Excel Worksheet Functions | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
text (3750 char.)truncates with text wrap and row heigh adjusted? | Excel Discussion (Misc queries) |