Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
151
Views
Topic starter
Hello everyone
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
Posted : 21/04/2023 6:56 pm
Change the ranges to tables
Posted : 21/04/2023 11:14 pm
