Get the 2nd, 3rd or the Nth Match value without Vlookup or Index Match Function | Easy Tricks |
#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,
https://bit.ly/GetNthMatch
To learn #Microsoft_Excel #VBA, #Dashboards, #Functions, #Formulas, #Pivot_Tables, You can check the #FREE #Course into this channel playlist #Technical_Portal..
🔶 Follow this YouTube 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 Financial Analysis Series
🔶 Microsoft Excel Short Codes of Macro & VBA
• Microsoft Excel Short Codes of Macro & VBA
🔶 Microsoft Excel VBA Series
• Microsoft Excel VBA Series
🔶 Microsoft Excel "LOOKUP" Series
• Microsoft Excel "LOOKUP" Series
Thank you all..!! See you soon Friends.. Bye..