@@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 ruclips.net/video/t0jqEJK6oDg/видео.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 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
ruclips.net/video/t0jqEJK6oDg/видео.html
Tq sir
thank well and good.But, i want the name one who score the same value, to display both the names of the entire list.
bottom scorer ka name kaise nikale?