After finding myself nested together with dozens other IFs in formulas for years, SWITCH was a genuine breath of fresh air when I found out about it, so much so that I tend to overuse it now.
Hey Allan, thanks for this video. Correct me if I am wrong, one of the difference with CHOOSE function is that CHOOSE first argument is always numerical.
Yes correct. So it has some strengths and many limitations when compared to SWITCH. Great that CHOOSE essentially chooses the value directly that matches the index number(s).
Very good Alan and thank you. I use this function to select any wanted range to bring correct column or row values. So useful and providing time saving
Love SWITCH! I would add that if you know 'all' of the values that should show up, it is good practise to make your final default argument throw an error with NA to show something is not as expected!
I have an excel sheet consisting of Term1 columns from Class I to VIII as shown below. Adm# Name Eng Hindi Lang Maths Science SocialScience, etc I want to share this single file among 16 persons (Class Teachers) for marks entry subject to condition that a class teacher can do marks entry only for his/her class and could not view or alter the marks of other classes. Once the data is entered in that single Excel sheet then by all 16 persons then I want to dowoad it and generate template specific Report Cards for all the students from class I to VIII? How to accomplish this task?
Thank you Alan. Love your style of teaching!
Thank you, Qasim.
After finding myself nested together with dozens other IFs in formulas for years, SWITCH was a genuine breath of fresh air when I found out about it, so much so that I tend to overuse it now.
Thanks, Giorgio. Yes, anything beyond a single decision IF function and its either SWITCH or a Lookup of some nature for me.
It is a function that is not widely used by the general public. The dynamic nature of the graph is very interesting.
Thank you very much for sharing.
You're very welcome!
Hey Allan, thanks for this video. Correct me if I am wrong, one of the difference with CHOOSE function is that CHOOSE first argument is always numerical.
Yes correct. So it has some strengths and many limitations when compared to SWITCH.
Great that CHOOSE essentially chooses the value directly that matches the index number(s).
Very good Alan and thank you.
I use this function to select any wanted range to bring correct column or row values. So useful and providing time saving
Thank you, Emre.
Love SWITCH! I would add that if you know 'all' of the values that should show up, it is good practise to make your final default argument throw an error with NA to show something is not as expected!
Nice tip! Thank you, Harry.
Yeah, this is what I often do with nesting IF(), and it's a nice reminder to do similarly next time I get around to using SWITCH().
I have an excel sheet consisting of Term1 columns from Class I to VIII as shown below.
Adm# Name Eng Hindi Lang Maths Science SocialScience, etc
I want to share this single file among 16 persons (Class Teachers) for marks entry subject to condition that a class teacher can do marks entry only for his/her class and could not view or alter the marks of other classes. Once the data is entered in that single Excel sheet then by all 16 persons then I want to dowoad it and generate template specific Report Cards for all the students from class I to VIII?
How to accomplish this task?