April 21, 2023
I have 3 classes and ranking the students according thier scores.for example: Class 1 from B2:B22, Class 2 B23:B45 and Class 3 B46:B70.
When the students of these classes increase or decrease, I manually change the ranges.
For example: Class 1 from B2:B28, Class 2 from B29:B50 and Class 3 from B51:B73.
Is there a way to change the ranges dynamically?
Thank you in advance