Forum Discussion
Beginner help on a ranking formula
Hello, First time posting here so hoping I'm doing this correctly. I'm trying to rank the below table using this kind of formula (it's for fantasy football). The top row marks the actual cell in ...
=ArrayFormula(INDEX($M$7:$M$18, MATCH(1, ($AF$7:$AF$18=SMALL($AF$7:$AF$18, AF7)) * (COUNTIF(AH$7:AH7, $M$7:$M$18)=0), 0)))
What is in AH7?
I'm not sure if I understood the question correctly, but wouldn't it be possible to create this as a table and filter to get the results you want?
Attached is a table with your formula.
Thank you for your understanding and patience
I know I don't know anything (Socrates)
Hi NikolinoDE,
AH7 was a typo, that should be AF7. I believe my formula is incorrect too since it isn't outputting what I would expect the results to be
