robgoldstein
Board Regular
- Joined
- Oct 26, 2013
- Messages
- 165
- Office Version
- 2019
- Platform
- Windows
I am trying to use a rank formula, but I want to exclude rows where a cell equals 0.
The equation I am using is =rank(Q3,$Q$3:$Q$17,false)
The cell I am looking to exclude is 'Toronto Playground _A_ 12U Spring 2023 Stats (2)'!BF3 If it equals zero.
So instead of being ranked out of 16 which is all the rows, it would only be ranked out of 10 if 6 rows contained zero in that BF cell
thanks
The equation I am using is =rank(Q3,$Q$3:$Q$17,false)
The cell I am looking to exclude is 'Toronto Playground _A_ 12U Spring 2023 Stats (2)'!BF3 If it equals zero.
So instead of being ranked out of 16 which is all the rows, it would only be ranked out of 10 if 6 rows contained zero in that BF cell
thanks