How to Match Two Sheets,Workbook Data | वीडियो को देखने के बाद आप डाटा मैच करने में मास्टर बन जाओगे
HTML-код
- Опубликовано: 2 окт 2024
- How to Match Two Sheets,Workbook Data | वीडियो को देखने के बाद आप डाटा मैच करने में मास्टर बन जाओगे
Download Practice File
docs.google.co...
About Video
Namaskar Dosto aaj aap is video mein sikhne ja rahe excel sheet mein data ko match karane ki techniques is video ko dekhne ke bad aap excel mein kisi bhi type ka data match kara payenge easily wo bhi sirf 2 minute mein yani ek word mein kahoon to aap chahe workbook ka data match karana ho chahe two sheets or multiple sheets ka data match karana ho aap insare mein master ban jayenge kaafi deeply explain kiya hai maine is video mein
Question & Queries
Match Data
match Data in excel
Match data in two excel sheets
match data in two column excel
Match data from one spreadsheet to another excel
match data in excel using vlookup
match data using vlookup
match data in excel using vlookup
match data using vlookup
match data in 2 columns
match data sets in excel
match data from 2 spreadsheets
match data from two excel spreadsheets
Follow me
👇
Instagram id:- / abhijeetjitechnical4m
Telegram:-t.me/abhijeetjitechnical4m
Advance Excel Formulas
👇
Vlookup Formula Part 1
• Part-1 | Excel Vlookup...
Vlookup formula part 2
• Part 2 | Excel Vlookup...
Subtotal Formula
• Subtotal Formula | इसे...
Countifs Formula
• Excel Countifs Formula...
Aggregate Formula
• Excel Aggregate Formul...
Sumproduct Formula
• Excel Sumproduct Formu...
Sumifs Formula
• Sumifs Formula With Mu...
Pivot Table Basic To Advance
👇
• Pivot Table
All the images & back ground music use in this video only for education purpose and all credit goes to owner
Disclaimer:--
Note: Copyright Disclaimer Under Section 107 of the Copyright Act 1976 allowance is made for "fair use" for purposes such as criticism comment news reporting teaching scholar ship and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use....
Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai
#matchtwoworkbooksinexcel
#matchdatainexcel
#abhijeetjitechnical4m
thanks for this informative video and explaining in a very easy way
Pure RUclips pe is video ko dhundhte reh gya aaj mila, mera problem solve ho gya ❤❤❤
12:26 Alt and press equal to for sum
Nice Video Thanku Sir
Excel sheet open but no editable and save option not shown
After open download it
Looking video 📸😊
value ko absolute ksy kia wo tu btya nh
F4 press karke
Also make a video on how to compare the two paragraphs and highlight the differences.
Many time putting vlook up formula brings NA because of some formatting issue... How to resolve those cases??
Download my app and message there through chat
App name - abhijeetji technical 4m
सर मुझे एक्सेल शीट में एंप्लॉय का सैलेरी शीट तैयार किया तो वह मंथ वाइज अलग-अलग सीट में जनरेट ऑटोमेटिक हो जाए उसके लिए कौन सा फार्मूला यूज़ करना कृपया आप मार्गदर्शन कीजिए
Sir, I have prepared the salary sheet of the employee in excel sheet, then it should automatically generate month wise in different seats, which formula should I use, please guide me.
Amin ji without see your data I can’t explain
If I want to match 2 columns in one excel sheet with 2 columns in other excel sheets
Ok then first combined both column (in first aheet) using concatenate formula and also combined both column in 2nd sheet then apply vlookup if srill u r facing problem u can join our Telegram channel and share your data pic there
How can I compare attendance from two workbooks in excel. Which is best and easy to use. In workbook names and id's are mentioned in one column and in another only names are mentioned.Workbook 1 contains both names and IDs (numerical) in one column.
Workbook 2 contains only names in one column.
Message me telegram with excel file
App ki vide baar baar doubling hoo ri hay means phir repeat hoo ri hay Jo student ko bohat parayshan ker ri hay. Kindly ais ko settle karayn
I think you have to learn in proper way you are the one person Jise samjhne mein problem aa Rahi so focus on learning
Sir thanks your support
Your vlookup formula is very useful... Best video for understanding
😊
Naam aur Baljeet ko alag alag kaise karenge batane ki kripa Karen
Can u explain
Wow! This is just amazing. The way you have explained, it's awesome. Great Work!!
your sheet data is not opened in correct ways..
Download app and message there
Dear sir practice fil dowanload kaise hoga
Click on download practice file
whts absolute free
How to reconcile two data in which between the description numbers are mentioned and we need to reconcile same numbers.
Yes you can do it with complex Formula
6:00 comparision of amt
I m not satisfied, due to if zip code double or triple so I can't handle
Then you have to use index with match function or Xlookup formula
Try Kiya par false ka option nhi aa rha hai???
What’s the problem
Unable to understand can u explain kaushik
Sir mere pass gadiya hai unko category wise karna hai.. if formula k sath try Kiya but ye ho nhi Raha hai... Jaise mere ek colum me gadi ka naam jaise Honda Amaze likha hai to hum ye chahate hai ki uske samne wale colum me apne aap wo car likh de.. agar main kisi bike ka naam likhu jaise Hero Spelandor tab uske samne apne aap bike likha aa jaye... Jaise auto likha ho to uske samne three wheeler likha aa jaye... Ab problem ye hai ki ye sab alphabet hai kahi bhi koi numeric value nhi hai... Please solve the problem.
Yes this is possible message me on instagram nahi to tum mere channel per hai aur advance if condition ki video hogi dekh lena kam ho jyga agar nahi hota message me on instagram
@@AbhijeetjiTechnical4M ok sir waise aapko maine insta par bhi massage kar diya hai.
Agar zip code, supplier name, city name, ya state mein kuda gadbad hai toh ? Aur ek hi example mein 2 columns mein problems hai toh ?
Can u explain not able to understand
@@AbhijeetjiTechnical4M while comparing two sets of data, if the difference is in supplier name, city name, or state, how to find the differences ? What if two columns have differences ?
Sir, how can we compare two excel sheets having various multiple duplicate entries?
First you have to convert both sheet into unique I meant remove duplicates then match
Sir aapne achhe se samjhaya hai
Good
Nice
Please make a video on how to compare and highlight differences of two table datas.
Formula freeze kyo karte hai
Kyonki jab formula ko drag karenge to range automatic change hota Raheja isliye hum use freeze kar dete hain
how to freeze the range
Select range and press f4 key from your keyboard
Love you brother
Very helpful sir
Well explained
Waah kya logic h, thumbnail h Match data only 2 Minut, aur VIdeo h 17 min ki.😅😂😂😅😅
Video mein explain Karke bataya Gaya hai by the way work sirf 2 minutes ka hai
💚💚💚
very good video
Abhijeetji. I am facing one problem.
1. I have one sheet having 18319 entries.
2. Each entry was checked in 13 samples with each sample having 3 replicates
3. I have already calculated the average of the replicates of all the 18319 in 13 samples.
4. Now I want to know that which entry is at least five times higher in a particular sample than its average levels in all the remaining 12 samples (the average I have already calculated).
How to do this. I am really worried as I have spent days on it and still unable to solve this. May you share your contact or any other mode of communication? so that I talk to you and share with you my file. thank you.
❤️❤️❤️
your teaching style is really amazing guru ji
Two different workbook match ka kuch nahi bataya.
Video available on channel visit my channel
@@AbhijeetjiTechnical4M THANKS