#multiplecriterialookup #leftlookup #indexmatch
#Excel has various formula and functions, in this video we have talked about certain Excel tips and tricks. After watching this video you will know about,
1. #IndexFunction
2. #MatchFunction
3. Left Lookup
4. #DuplicateRemoval
5. How to create #dropdown
6. Multiple criteria #lookup
00:00 Intro
00:41 Showing Result
01:40 Index Function
02:33 Match Function
03:28 Left Lookup
06:55 Creating Drop down
09:40 Multiple Criteria Lookup
14:30 Conclusion
We have already posted certain videos on #Exceltipsandtricks, it is available in #playlist - https://www.youtube.com/watch?v=6xjqhQXHGMg&list=PLIo8gVJ3LwqhkLGdoyZWW1UTKUT2jGXHV
If you have any queries, recommendations, questions please post it in comment section.
Subscribe to:
Post Comments (Atom)
3D Formula in Excel - Excel tips and tricks
#3Dformula #Excel When working on multiple sheets 3D Formula in Excel helps to work smart and saves time while creating summary. It is o...
-
Prizes: Cash Prize of Indian Rupees 5000/- for No.1 Video Creator Complementary Prize for 10 Video Creators of Indian Rupees 500/- Each. Las... -
Watch the video above... #BoxPlot #Histogram #Colab Creating Box plot / whisker's plot and histogram using Google Colab #python wi...
-
#Correlation #StockAnalysis #GoogleColab Correlation explains the relationship between two variables, Correlation coefficient is a mea...
No comments:
Post a Comment