Get the 2nd, 3rd or the Nth Match value without Vlookup or Index Match Function | Easy Tricks |
Вставка
- Опубліковано 26 сер 2024
- #Microsoft_Excel #TECHNICAL_PORTAL
Hello everyone. Here in today's video we are going to check the process to get or find the 2nd, 3rd or the Nth matching value of your excel worksheet without using the Vlookup or the Index-Match function. Here we are going to create a Data Validation list and Named Ranges also.
Queries solved into this video:
1. How to get Nth Match from your database
2. How to use the Small Function properly
3. How to use the Row Function Properly
4. What is Named Range in Microsoft Excel
5. What is Data Validation
6. How to create Drop-down List in Excel
Here is the data file used into this video,
bit.ly/GetNthM...
To learn #Microsoft_Excel #VBA, #Dashboards, #Functions, #Formulas, #Pivot_Tables, You can check the #FREE #Course into this channel playlist #Technical_Portal..
🔶 Follow this UA-cam Channel to get more practical Stuffs..
/ technicalportal
🔶 Follow this page for regular updates,
/ technicalportal646
🔶 Follow our Twitter Page,
/ techport646
Please watch previous videos here,
🔶 Microsoft Excel Financial Analysis Series
• Microsoft Excel Financ...
🔶 Microsoft Excel Short Codes of Macro & VBA
• Microsoft Excel Short ...
🔶 Microsoft Excel VBA Series
• Microsoft Excel VBA Se...
🔶 Microsoft Excel "LOOKUP" Series
• Microsoft Excel "LOOKU...
Thank you all..!! See you soon Friends.. Bye..
Thank you so much sir, this helped me a lot.. Thank you...
Glad to hear from you... Thank you for your support...