Forum Discussion
nth Largest value with conditions
Hi. I'm working with a data set from a game that contains player ability ratings, names, positions and a couple other values as well. I am able to get the nth values for each team, but would like to ...
Twifoo Here's an updated version with the conditions I'd like to apply and two fake teams who violate the parameters
I presume you want to return the results of Columns AS:AY. What's the logic for 80, 78, and 20 in AS4, AT4, and AX5, respectively?
Yes, I would like to return those values if the conditions are violated in the top 20. Those values are less than the 20th place and wouldn't show just based on a LARGE formula