Excel Tutorial to find Top Bottom "N" Values in a Data
Спорт
A Tutorial to help you in finding the TOP N or Bottom N values in a data. Can be very helpful for Analysis & Reporting.
🔶 Get the Practice Excel File Here : bit.ly/36YvMX4 🔶
Software Tools/Products by Teknisha:
🔷 gumroad.com/teknisha🔷
Recommended Gadgets/Products:
www.amazon.in/shop/teknisha
Must Watch Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/TeknishaSubscribe
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha_
Пікірлер: 11
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
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.
thank you sir
@TEKNISHA
2 жыл бұрын
Happy that this helped out
@khansvirtualdiary
2 жыл бұрын
@@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
@TEKNISHA
2 жыл бұрын
Hi. I have already made a video for this. Check it out Excel Tutorial to Sort Data Automatically without using Macros kzread.info/dash/bejne/pmSe06eDe5nVdMo.html
bottom scorer ka name kaise nikale?