hi folks,
I have an excel sheet I am working on and can't for the life of me solve this one.
I have a range of data in cells G15:J35.
1. I want to find the top ten (for example) values in column J (stored as percentage) and return the value in column G.
2. Then I also want to bring back the value from those same top ten.
I have tried using the following formula, but it does not seem to bring back the correct values. (londonerrors is the name for the data in column J)
=INDEX($G$17:$G$35,MATCH(LARGE(londonerrors,ROW(1:1)),londonerrors,0)) for point 1
=INDEX($G$17:$J$35,MATCH(LARGE(londonerrors,ROW(1:1)),londonerrors,0),4) for point 2
It seems to find the first instance of 100%, even when changing the ROW(1:1) part to ROW(2:2) and so on. Is it being affected by the fact there are multiple with 100%?
Bookmarks