Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel formula query
Name: SarahJ Date: August 13, 2005 at 06:49:08 Pacific OS: Windows XP CPU/Ram: 800mhz
Comment:
I have created a spreadsheet with names in column A and weekly values/scores in each subsequent column. I need to create a formula that will identify the highest scorer of the week by displaying the name that appears in column A. I can identify the highest score using the MAX function but need the formula to display the name of the person. Can anybody help?
Name: Bryco Date: August 13, 2005 at 08:55:13 Pacific
Reply:
The easiest way that I can think of is to have your scores to the left of the names.
Use the MAX formula to determine the first highest score and then use VLOOKUP off of that cell to find the corresponding name for that score for that column. (Note: MAX will only return the single highest score. If two or more have the same high score then MAX will only show the first)
Another way would be to Concatenate the score and name columns (eg. A2&" "&A1=85 Mary) for the full range. Copy and paste special values in place and then sort decending.
The OFFSET function may help if keeping the Names in the leftmost column.
There are more ways to accomplish your task.
HTH Bryan
0
Response Number 2
Name: Bryco Date: August 13, 2005 at 10:01:59 Pacific
Reply:
I get it now..You are using MAX to find the high score for the week.
I too am unable to get the name from that.
I sent an email to you with a spreadsheet with a way to do it although it is definately not the easiest way to do it. See the formulas in columns H and I.
Bryan
0
Response Number 3
Name: SarahJ Date: August 13, 2005 at 11:14:41 Pacific
Reply:
Thanks for that Bryan it has worked a treat!
0
Response Number 4
Name: Bryco Date: August 13, 2005 at 12:39:51 Pacific
Summary: I have created an Excel query in Office 2007 to return a specific set of values from within a named range in my spreadsheet (for example, the 6PM temperature from all days in March from a range contai...
Summary: Hi All I need some help with a certain Excel formula. Hopefully my explanation is clear enough. Basically I have 3 columns - Days, Hours and Minutes. Currently I put in data for each column and it is ...
Summary: For no apparent reason I have encountered problems with excel formulas. Instead of dragging formulas across columns, my speadsheets are copying information only. Also, summed columns of figures are no...
0 
