🤓Extract All Data Of Same Repeated Lookup Value 👍 Using Vlookup In Excel || Hindi
Вставка
- Опубліковано 25 сер 2024
- Vlookup formula in excel hindi to extract all data for same lookup value every excel user must know.. using countif formula . Vlookup Results from Repeat Values in excel to find the results of the same person with repeat data entries. how to find duplicate information in Excel? Quickly find and delete duplicate data in Excel with this easy function. While there are many ways to find duplicate data this is the fastest and most efficient. #VLookup is an important lookup function at this time. When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of #Excel in Windows and Mac, and also in Google Sheets. It allows you to find data in one table using some identifier it has in common with another table. The two tables can be on different sheets or even on different workbooks. There is also an HLOOKUP function, which does the same thing, but with data arranged horizontally, across rows. #deepakeduworld
Download Training File : drive.google.c...
best video to learn Excel iferror formula in excel
• How to use IFERROR for...
How To Use Name Manager And Define Name in EXCEL | In Hindi
• How To Use Concatenate...
how to use concatenate formula in excel | Hindi | join data of different cells into a single cell
• How To Use Concatenate...
countif formula in excel in hindi
• COUNTIF formula in exc...
VLOOKUP VIDEO SERIES:
1. vlookup in excel with example in Hindi
• Vlookup in Excel With ...
2. How to use vlookup for multiple values || Trick to use vlookup for large data
• सारा Data एक बार में V...
3. Vlookup in multiple sheets in excel || In Hindi
• Vlookup in multiple sh...
4. How To Use Double VLookup in Excel-Nested vlookup
• How To Use Double VLoo...
5. Dynamically Updated Vlookup Formula in Excel
• How To Make a Dynamica...
6. How To Use Vlookup With Multiple Excel Workbooks
• How To Use Vlookup in ...
7. HLOOKUP in excel with example in Hindi
• HLOOKUP in excel with ...
8. vlookup Magic 😮 Trick - Vlookup नहीं Smart Vlookup 👌 सीखो अब..
• Vlookup Magic 😮 Trick...
9. Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
• Index Formula in Excel...
10. How To Use Vlookup 👉 For Multiple Lookup Values In Excel
• Vlookup in Excel in Hi...
11. How To Create Picture Lookup In Excel 👉 image vlookup लगाना सीखो 😎
• How To Create Picture ...
12. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
• Index + Match Function...
13. Vlookup Powerful 💪 MAGIC TRICK 👉 Marge data from multiple Excel workbooks into one
• COMBINE Multiple Excel...
if You are computer user, excel user, ms word user, power point user, sql user, and want to learn computer tips & tricks in hindi, excel tips and tricks, excel secrets, excel shortcut tricks, excel formulas, office work in excel, ms word tips & tricks, power point tips, computer technology ,then must visit our channel deepak eduworld and subscribe.
Deepak EduWorld Playlist's:
ADVANCED EXCEL ► goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ► goo.gl/bbHYu2
Excel Tips & Tricks ► goo.gl/wAj1jh
MS WORD ► goo.gl/B4TeSA
HTML5 & CSS3 ► goo.gl/2PFgs8
COMPUTER TECHNICAL videos ► goo.gl/paZmpn
Automatic Invoice's in excel ► goo.gl/dFhg54
Subscribe to Deepak EduWorld ► / deepakeduworld
Tags:
Vlookup formula in excel, excel vlookup functions, deepak eduworld, deepak nehra, excel tutorial, excel tips, computer tips, vlookup multiple criteria, multiple lookup values, vlookup multiple columns, excel user, computer user, vlookup repeated values
![Advanced MS Excel - Hlookup With Match Function [ 2D Lookup ] In Hindi || Deepak EduWorld](http://i.ytimg.com/vi/JIN0NBVuEsg/mqdefault.jpg)
![Advanced MS Excel - Hlookup With Match Function [ 2D Lookup ] In Hindi || Deepak EduWorld](/img/tr.png)
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
Vlookup Full Tutorial Basic to Advanced
ua-cam.com/video/V4YgQTFLmyc/v-deo.html
sir jo recruitment hai plz usi ke bare me btao jo apne link beja hai time period jyda hai or confusion part bhi hai so plz same value ko 2 worksheet me kese find karte hai plz
ua-cam.com/video/-W9A9mSKpHQ/v-deo.html
8200794895 Contact me sir
@@gelotylashtash4665 l
Hello sir..how are you
Sir i am a sales person. I have 6 routs in a week. And visit every each area 48 times in a year. Now i want to get every area sale consolidate in one cell....
Please give guide me..thank you
In Excel 2016 and above version this huge brain works reduced.
Select Data and convert as a Table and Directly insert Slicer (Hardly it will take 2 minutes) also it will give you more options to choose another look-up filter (e.i Slicer)
Anyways Awesome job. 👍 for those who are not yet reached in Excel 2016
दीपक मैंने आज आप का वीडियो देखा । सही मायने में आप गुरु हो। Excel पर आपका कमांड जबरदस्त है।
Great Sir... You are saving my 1/5 times of my office work... Thank You Sir.
This was so helpful man. I wasted time watching other channel videos. This was the most useful. Keep making videos like these, I mean excel.
Thank you sooo much
Thank you deepak ji mai kai dino se pareshan tha na jane kitni sari vidio dekh dali iske liye but finally aapka video dekha. Very helpful for me. So thank you again.
Sir ji........mere khvais puri karhi di aaap ne........ Thanks..........🙏🙏🙏
I love this channel............Yes you're ON..........
Well, sir I would like to tell you that which you have told me under 17:06 minutes, that the same work I took approximate forty five to fifty minutes. Thank you so much for this concept.👌👌👌👌✌✌
Duplicate value in vlookup wale comment ka sahi jawab hai . Thanks
sir abhi tak aap jaisa clear video pure UA-cam main kahi nahi hai
Thank you so much sir. You have solved my big problem. I am looking since long time this solution
All Excel Lookup Function: ua-cam.com/play/PLl2uwOt1hHQtb5FzyeJezM3bzZAm2B1qr.html
This was a wonderful explanation - very clear and to the point. Very helpful. God Bless you!
Kamal ki video hy bhai. Me is video k lye hht search kia par mujhe shayd pta nahi ta kaise search karna hy. Me ne apky invoices wale 3 parts ki video dekhi wahab bhi sawal pocha tha k kahi aisa nahi ho sakta k me invoice no lekho or dosre sheet se us invoice k against sara data mere invoice me ajay or invoice tayar ho jay. Ab ye kam sekh kr mera kam asan ho gia. Me simply apne invoice me invoice ka no dunga or us invoice k tamam product pehli sheet se copy ho jaingay.
I mean thanks alot. Ap ne kam bht asan kar dia. Thank u so much
🤗🤗🤗😊😊😊😊😊
Keep learning.. keep supporting 🤗
Thank you very very very very very much. You have no idea how much this video was helpful for me. After 30+ videos I got a solution to my data management because of this video. Kudos to your knowledge on excel. Simply Hats off. :)
Ap se bada koi master nahi you tube par
want to learn office 2019 and office 365
Bhai g bhot bhot dhynywaad apka mera sara kaam isi k chkkr me atka pda tha tnks a lot deepak sir
THANK YOU VERY MUCH DEEPAKJI. THANKS FOR SUCH A VERY EDUCATIVE VIDEO. I AM NOT ONLY A SUBSCRIBER OF YOUR CHANNEL BUT YOUR FAN ALSO AND I HAVE LEARNT EXCEL EASILY FROM YOU. THANKS.
Sir boht e Zabrdast banya ha man nay is sy boht benefit b liya ha Thanks 😊 ab agr ap is ka koi or soltion dy den Xlookup kay sath to ziyda best ho ga q kay jab ham 40000 tak entries kar rahy han to sheet hang boht hoti ha so agr ap Xlookup kay sath dy den to asan ho jaye ga
This can also be used to bring values from adjacent cells at one place of duplicate items & identify the differences between them. Good demo. 👍🏻
thanks Deepak for Excellent explaination -
I saw your video on you tube and I taught my computer teacher this trick.
lean more office 2019 and office 365 new formulas and new function
please visit my channel also.
for vlookup
ua-cam.com/video/1noGHCUGxUM/v-deo.html
Channel link
ua-cam.com/channels/Yalru61E3cHHeHqHW3cT_A.htmlabout
Graphic image you title is to the point, and excellent presentation
Apka ye video mera bohot kam me aya..thanks sir..apka ye video ne mera bohot help kiya..mene ye karne ka bohot try kiya tha lekin nahi ho paya..apka ye video dek kar samaj me a geya..thanks..🙏
😁👍👍👍
Well done.... its works and I was searching kind of solutions no foreign videos has this solution. Only this indian gave me... it
वेरी वेरी थैंक्स सर
मेरी कई दिनों से यह समस्या का समाधान नहीं हो पा रहा था आपके प्रयास से मेरी समस्या का समाधान हो गया है इसके लिए आपको विशेष धन्यवाद वाकई मैं स्ट्रीक के लिए और इस फॉर्मूले के लिए आपका बहुत बहुत आभारी रहूँगा। वाकई आई एम वेरी हैप्पी सर
By सब्जेक्ट ज्ञान यूट्यूब चैनल
😊
Thank you thank you thank you...so much sir....!!!! U resolve my problem...!!!!
Lockdown me ghar per hu to apke video se bhaut kuch sikh gai hu thk u
Thanks sir it's very useful for me at workplace
This formula is very useful for Those who doesn't have excel 360
Thanks you so muchhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh
It was my need today..........................From Pakistan Punjab Faisalabad
Great. You explained in a very professional way that anyone can understand easily. Thank you
Great sir,
Kamal kar diya aapne sir
मज़ा आ गया सर ।
Hi Mr. Deepak, you have created a very informative video. I have followed the same instructions using the Vlookup function. All things work perfectly except date. It cant copy the date from the data.
Thank you so much sir ji I am frm Kashmiri j&k India .... U solved mine big problem ...
Aap ki sari vdo smjh me ati h
I can't thank you enough. Such an amazing video. This is exactly what I was looking for. Keep up the good work.
Good job sir
This trick ko mai 1 years se dhund rahath
Very informative... thank you for sharing
This was really very helpful. You solved my long time problem in one shot. Thanks a lotttt♥️
Very very thanks this video helps me alot
Dear sir it's very helpful tips
Thank you very much for the vedio and good explination with details
Thank you for very useful vedio
Very nice presentation
Tanks you so much sir great job 🙏👍
excellent topic and elaboration on concept
जबरदस्त सरजी. U r great
Sr Bina vba ke cash book entry ke liye koi vedio bnao Sr ...jisme monthly data or yearly data print.....edit...new work entry ...search .......aap bhot acha or detail se samjate ho sr.....or aasani se samj me aa jata h sr
😊😊🤗🤗👍👍👍 as soon as possible
Wow. You accomplished exactly what I was looking for. Thank you so much!
This is an amazing method. If u want to know everything about vlookup including multiple match here is my must watch recommendation.
ua-cam.com/video/vi4olGGjnN4/v-deo.html
Dear Deepak very useful.
God bless you Deepak. Stay Happy.
Thanks sir for this video and also like all video for extra knowledge
Mujhe same yhi interview m pucha gya tha pr us time pta nhi tha
Ab sikhke jaunga
Deepak you are doing great job,
Keep it up 👍👍
What an wonderful explanation. Thanks for the work.
That's i was finding sir 🙏🙏🙏
Bhagban me kabse yehi dhond rahathaa🙏🙏😘
hi. I was successfully able to use this formula to pull specific data from limited columns into another sheet. I have 2 queries -
1) If I want all the data to come on the filtered sheet then what should I do. For now i am getting only specific data. eg. Filter data on priority i.e. High, Medium, Low and Lost. But if I want all 4 of them.
2) If I want the data to be filtered by a second criteria aswell i.e. Accounts manager, then what should i do.
Awaiting your response. Thank you so much in advance.
Very nicely explained.. very good... sir... very useful in my practical work place... Thanks a Lot...
At the present circumstance we do not have enough time for applying long procedure so instead of this one we apply privote table all the data will emerge accordingly sir as well as we must use Excel 2016 and above version which will Hardly take 2 minutes and problems will going to solved. what do you think so sir. but your effort is valuable and we salute you sir.
Good Sir aaj mera man bhar gaya sir
thanks this video helps me a lot. Got my intended result withing in minute
Dada Nomoskar. Just Wow.
Excellent tutorial Deepak!! You are a genius...
Well explained deepak
Thank u Deepak sir
U r genius
very educative tutorial .
🤗🤗🤗😊😊
Very good Sir Thenks
Good video... advance bhi baki ka batate ho
Thanked what I was looking for...saved my day
Thanks for sharing 🙏
Thank u sir just great idea
Wonderful explanation keep it up
Thanks sir this video very very helpful 😊for me.
bhaut badiya sir
Waoo. Thanks GURU JI. i got my answer by this video. THANKS. thats the method i was want to know
😇🤗
Ek no. Bhai, advance formula
I was struggling in this task.... Thank you so much sir...
🥰
Sir do we have other way if dont want to use & function... Mean vlookup based on two value.. Not using &(helper)
@@RahulGupta-iv5ku yeah u can exploit the array nature of excel instead .
This is an amazing method. If u want to know everything about vlookup including multiple match and multiple lookup value here is my must watch recommendation.
ua-cam.com/video/vi4olGGjnN4/v-deo.html
very usefull for my office work thanku so much sir...
You are the best
Thanku sir🤗🤗🤗🤗🤗
Wonderful Trick sir..
I liked it and also applied on my data
lean more office 2019 and office 365 new formulas and new function
Multiple sheet e data kam karega?
Nice wok man, although I don't speak Hindu but I still managed to understand every thing.
👌 video Deepak
Nice thank you so much
Thanks Deepak. Its really nicely explained. How can we use this macro for increasing data?
Sir very nice sir apki ek video dek raha ta wo Jo English mein advance Excel k bare mein bataya hai Jo advance Excel ki videos hai oska link bej do muje plz sir ...
Excellent explanation, thanks
very nice deepak ji... its very imp.
lean more office 2019 and office 365 new formulas and new function
Perfect way of teaching
Sir due to your this video i able to make exlent data sheet. While asigning columns formula it calculates horizontal num of Rows- in my table due to one merged cell the calulation is not appearing as per requirment. Your Video is very very helpful for my self learning. Thanks once again
Very Very Thanks venerable sir, I am Proud of you.
Sir This is very usefull video thanks for learning for this excel formula
thankyou very much brother very very useful content
Bro it's really amazing ...keep it up bro 😍
Thank you very much...! It helped me a lot..!
Thank you so much sir.
Thank you so much sir ❤
Thank you very much for your great help... i look forward your further videos in android/ios excel...😆😆 Besically i have problem in dropdown list(data validation) in android...
Gzb smart se bhi smart lookup
Very Nice Explain Sir 🙏