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...
=LARGE(IF($C$2:$C$25=H$4,$D$2:$D$25),$F5)You can try this formula for the dataset of the attached example. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- 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
- unfortunately this this gives me n/a
