Forum Discussion
Index Match
I need to find a way to find a way to use index match or another lookup function to pull the 1st, 2nd, 3rd, 4th, 5th largest number from a data set based on a criteria. For example, I want to find th...
unfortunately this gives me an n/a
Perhaps you may drop small sample file or at least screenshot?
So I want to find the top 5 largest numbers in column AP, given that it has the criteria of "Fixed Income" in column AO
- in column AP its a formula I've created to calculate those numbers