@@TEKNISHA Thanks sir for your kind response. I would like to request you make a supplementary tutorial to this one: If you have time in future. Following your video i tried to make an automatic result sheet by my self for skill up purpose . Formula you used helped me a lot to reach easily while number of students in class 20 or 50 . But If i want to create auto ranking based on total marks as 1st 2nd 3rd 4th 5th so on, what will be the technique ?? I did it manually by using data sorting (A-Z) formula. But the column is not automatic as when i change change value in respective cells the rank level remains same !! Best wishes for your channel, sir
Hi. I have already made a video for this. Check it out Excel Tutorial to Sort Data Automatically without using Macros ua-cam.com/video/t0jqEJK6oDg/v-deo.html
At first I thought of only liking your video, but by the end you earned my Subscription 👍
Just what I was looking for, thanks
This is great! Can you tell me how to get the names as well to show with the top 3?
thank well and good.But, i want the name one who score the same value, to display both the names of the entire list.
Thank you for this, now how do i put this in a visual like a bar chart
thank you sir
Happy that this helped out
@@TEKNISHA Thanks sir for your kind response. I would like to request you make a supplementary tutorial to this one: If you have time in future. Following your video i tried to make an automatic result sheet by my self for skill up purpose . Formula you used helped me a lot to reach easily while number of students in class 20 or 50 . But If i want to create auto ranking based on total marks as 1st 2nd 3rd 4th 5th so on, what will be the technique ?? I did it manually by using data sorting (A-Z) formula. But the column is not automatic as when i change change value in respective cells the rank level remains same !! Best wishes for your channel, sir
Hi. I have already made a video for this. Check it out
Excel Tutorial to Sort Data Automatically without using Macros
ua-cam.com/video/t0jqEJK6oDg/v-deo.html
Tq sir
bottom scorer ka name kaise nikale?