Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return value from column A if value in column B is in top 3 MAX()
In my worksheet I have a list of scores in column B, and in column A the
corresponding question. What I'd like to do is show a list in another worksheet of the top 3 scoring questions in decending order. Example: data sheet (comma seperated) Question,Score 1,70 2,89 3,90 4,65 5,99 6,55 Example: results sheet Question 5 3 2 Thanks in advance, Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return value from column A if value in column B is in top 3 MAX()
Try this.
Assume you want the formula in sheet Results starting in cell A1: =MATCH(LARGE(Data!B$2:B$7,ROWS(A$1:A1)),Data!B$2:B $7,0) Copy down to A3 -- Biff Microsoft Excel MVP "porter444" wrote in message ... In my worksheet I have a list of scores in column B, and in column A the corresponding question. What I'd like to do is show a list in another worksheet of the top 3 scoring questions in decending order. Example: data sheet (comma seperated) Question,Score 1,70 2,89 3,90 4,65 5,99 6,55 Example: results sheet Question 5 3 2 Thanks in advance, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup a value in column B but return value in Column A | Excel Discussion (Misc queries) | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
if column 1=3 then column 2, if not return no value-Help? | Excel Worksheet Functions | |||
Lookup in one column, and return value from another column | Excel Worksheet Functions | |||
Search one column and return value from next column | Excel Discussion (Misc queries) |