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 |
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 |
All times are GMT +1. The time now is 12:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com