Find Top 5 Values and Names in Excel
In this video, I'll guide you through the methods to find the top 5 values and names in Excel.
You'll learn different ways to find the top 5 values and corresponding names, using functions like LARGE, ROWS, INDEX, MATCH, COUNTIF, SORT, FILTER, SEQUENCE, CHOOSEROWS, COLUMNS, XLOOKUP, and IF. Techniques include creating unique identifiers, removing duplicates, matching values with names, applying criteria, using pivot table slicers, highlighting with Conditional Formatting, and VBA. Identifying values and their corresponding names enables you to enhance the clarity and maintainability of your formulas. Additionally, it facilitates the conversion of text into numerical representations, provided the text denotes a numeric value in some form. With practical examples and step-by-step instructions, you can effortlessly find the top 5 values and names in your own Excel spreadsheets.
👨🏫 Instructor: Shahriar Abrar Rafid
🎥 Editor: Sadia Rahman
✨ ⯆ Resources:
Alt+F11 - To open Visual Basic
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
1:01 - Finding top 5 values and names with duplicates
1:28 - Using combinations of LARGE, ROWS, INDEX, MATCH, LARGE & COUNTIF functions
5:26 - Joining SORT, FILTER & LARGE functions
6:56 - Combining CHOOSEROWS, SORT & SEQUENCE functions
8:42 - Using INDEX, SORT & SEQUENCE functions together
9:42 - Finding top 5 values and names By creating unique identifiers
13:05 - Using LARGE & COLUMNS functions together
14:29 - Extracting top 5 values and names without duplicates
14:39 - Using LARGE & ROWS functions together
15:37 - Finding top 5 names by matching top 5 values
15:47 - Using INDEX, MATCH, LARGE & ROWS functions together
16:35 - Combining XLOOKUP & LARGE functions
17:24 - Finding top 5 values and names With criteria
17:45 - Using INDEX, MATCH, LARGE & IF functions
18:47 - Applying INDEX, SORT, FILTER & SEQUENCE functions
19:12 - Finding top 5 values and names based on multiple criteria
20:31 - Inserting pivot table slicer to find top 5 values and names based on criteria (Without Formula)
22:26 - Highlighting top 5 values and names using Conditional Formatting
23:34 - Finding top 5 values and names using VBA
📚 ⯆ DOWNLOAD the workbooks here:
https://www.exceldemy.com/wp-content/...
https://www.exceldemy.com/wp-content/...
🌍 ⯆ Checkout the article here:
https://www.exceldemy.com/find-top-5-...
💻 ⯆ Similar Videos:
• How to Extract Unique Values Based on...
• How to Create Multiple Sheets with Di...
🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: / exceldemy
Twitter: / exceldemy
LinkedIn: / exceldemy
🙋♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.
ExcelDemy Forum: https://exceldemy.com/forum/
👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications, so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!
🔔 ⯆ Subscribe on YouTube:
/ @exceldemy2006
#excel #exceltutorial #exceltips #exceltricks
Смотрите видео Find Top 5 Values and Names in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ExcelDemy 07 Май 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,56 раз и оно понравилось 1 людям.