Compare two excel file with unique identifier | Compare two sheet in excel in Hindi
HTML-код
- Опубликовано: 13 ноя 2021
- We have excel add-in which help us to compete two excel workbook. we need to enable few add-ins in excel. this video will teach you how to compare two excel worksheet with the help of unique identifier.
#Excel
#GyanOnTube
#MicrosoftExcel
#Exceltips
Download Link 1 :- docs.google.com/spreadsheets/...
Download Link :- docs.google.com/spreadsheets/...
excel in hindi
compare two sheets in excel
compare two sheets in excel for duplicates
compare two sheets in excel for matches
compare two sheets in excel for differences
compare two excel sheets
compare lists in excel
compare two excel worksheets
excel
Ms excel in Hindi
compare two sheets
compare two excel files for differences
excel formulas in Hindi
compare two excel files
learn excel
compare lists in excel for matches
*********FOLLOW ON*************
Facebook :- / excelworldofknowledge
Twitter - / sohandey3
Follow me on Instagram :- / sohandey_got
______________________
POWER BI
Power BI In Excel In hindi :- • Power BI In Excel In h...
How to use Power Bi from beginner to advanced :- • Power Bi in hindi || H...
Power Bi में अपना काम सेव एंड रिकॉर्ड करे :- • Power Bi in Excel in h...
Power bi tutorial for beginners :- • Power bi tutorial for ...
Power BI dashboard :- • Microsoft Power BI In ...
Microsoft power bi in hindi :- • Power Bi tutorial for ...
Microsoft power bi course for free :- • Power Bi for beginners...
Delete unwanted columns in power bi :- • power bi tutorial for ...
Text to column in power bi for beginners :- • Text to column in powe...
Power BI with New Icon in 2020 :- • Power BI with New Icon...
Power Bi Reference option :- • Power Bi Reference opt...
Edit Data in power bi manually :- • Edit Data in power bi ...
power bi tutorial for beginners in hindi :- • power bi tutorial for ...
power bi dax tutorial for beginners :- • power bi dax tutorial ...
Power BI relationships between tables :- • Power BI relationships...
Excel formula
How to use index match formula from Basic to advance :- • index match excel || H...
How to make big formula in excel in hindi :- • combination formula ||...
Xlookup and Filter formula in hindi :- • Xlookup for Free || Ne...
How to reduce excel file size :- • compress excel file ||...
How to use Xlookup in excel :- • How to use Xlookup in ...
xlookup formula in hindi :- • How to use Xlookup in ...
array function in excel :- • Array formula excel ||...
New Xlookup with Search Mode :- • xlookup in excel in hi...
Xmatch formula in excel in hindi :- • Xmatch formula in exce...
how to use filter formula in excel in hindi :- • filter formula in exce...
Excel formulas and functions:- • Top 10 excel formulas ...
How to use excel unique function:- • How to use excel uniqu...
Sort formula in excel :- • Sort formula in excel ...
Pivot Table
pivot table from beginner to advanced :- • how to use pivot table...
Pivot table in hindi :- • Pivot Table In Excel |...
How to use pivot table excel :- • How to use pivot table...
Pivot table in hindi in excel :- • pivot table excel from...
Drill Down in Pivot table excel :- • Drill Down in Pivot ta...
Pivot Graph in excel in hindi :- • 3D Pivot Graph in exce...
how to use pivot table slicer :- • excel slicer || how to...
IF formula in Pivot table :- • advanced pivot tables ...
power pivot in excel :- • power pivot || how to ...
how to link data in power pivot in hindi :- • power pivot in excel |...
how to use power pivot in excel in hindi :- • power pivot in excel |...
Gyan On Tube Excel
Sohan SirG, Shaandaar, Behtareen, trick hai ye, maine to kabhi dekha hi nahi tha !!!
Thank a lot, SirG hats off to you. Dhanyawad...
Thank you so much Nitin..keep supporting..and do not forget to share this video
Awesome features with new learning in great Way. Thanks for sharing sir Happy Learning 😊 😊
Thank you so much for your support 🙏🙏
U made life easier for many peoples, keep up the good work 👏🙌
Thank you so much for your valuable comment..do not forget to share this video
You are Awesome, love from pakistan
Thank you so much
Awesome sir
Thank you so much
Thank you 😊
Thank you so much..do not forget to share this video
Awesome
Thank you so much
Beautiful
Thank you so much..🙏🙏🙏
Very nice
Thank you so much..do not forget to share this video
Good
Thank you so much
Thanks for the brilliant presentation of a most useful add on in excel. However, I use latest version of MS Office 365 but I DO NOT GET the add in options of either Inquire or Compare Sheets. You have previously mentioned an upgrade of excel in a reply. Kindly specify what upgrade is required to get the add ins. I am using Home version not Pro ver. Thanks in anticipation.
You need to have the latest version of excel which is office 365
Best logic
Thank you so much
Good
Sir aapna Two workbook ko compare kiya hai.
Bahut achha laga
Lakin ek workbook ma two sheets ko kaisa compare kara.
Same option aata hai waha
Hi, it is really awesome video. I need to know something more. Please let me know if data are not in same order (here both sheets have same data with some missing), can we compare ? How can we compare it using macro?
Yes we can do that on the basis of macro only
@@GyanOnTube any video regarding this if yes please share the link if not then please make a video regarding this also
hi bro, its a good trick, i need this but in my office 365 there is no in build for com add in, where can i add it ?
You can upgrade your excel you will get that option
Sir ek issue ho raha usme likhta at list' two workbook are needed to compare
Means..???
Bro financial dashboard wala videos bana do normal excel wale jaldi 👍
Aapke pass koi demo data hai to mujhe send kariye.. telegram group mein
Sir. Bank reconciliation kar sakte hai kya is se.. 2 statement kaise compare kare aur kaise resolve entry highlight kare..
Bilkul kar skate hai..same way..
If a sheet has month wise data along with product but few months are missing in front of few product (both month & product data is in column only) den how can we fill dat thru formula
Then it will not calculate those data which do not have month name
Whenever i clicked on to compare its show me pop says- at least 2 workbookss are needed although i opend my sheet just like u can u hlp me?
Need to check your data
Boss the below option is not showing in excel 2016 kindly suggest
You can get it from google
Bhaiya ab is inquire ko kaisa hataya, normal kaisa kara.
Jaisa pahala tha . please reply
Same steps ko repeat karo
Hello sir,
6 Excel sheet hai, har sheet me stock item hai (kitna kharch hua aur kitna bacha hua hai) sabhi sheet ka grand total pahli sheet me karna hai. Kaise karenge aur kaunsa formula use hoga.
Are very easy..use power query..
@@GyanOnTube Hello sir,
Sir mujhe stock ki master list banani hai Excel me. Hamare yahan Welding electrodes aati hai, 2MM, 3MM, 4MM & 5MM ki. Ye electrodes dusre department se issue hoti hai hamare liye harr hafte aati. Hum candidates ko harr MM ki electrodes issue karke dete hai welding ke liye daily bases pe. Sir mujhe sheet kaise banani hai. Kitni hum other department se electrodes issue kar rahe hai aur hum kitni candidates ko de rahe hai. Kitne received ki department se. Kitni hamne candidates ko issue Kari daily basses pe aur kitni balance total reh gayi. Master balance list kaise banaun with formulas. Plz help me
Hello sir, nice but inquire option not showing
Which version of excel you are using
I need this practice link
Its below in description column
सर मेरे पास एक excel का data है उसमे से data extract करना है 6 Criteria से
Will You Help me.
Kya aapko data extract karne mein koi issue aa raha hai
Question - How can I save the result file in Excel to see the comparison.
Which file you want to save
Agar dono sheet se same data nikalna hai tab kya kre
Sheet ko merge kar
from where to download this com add in
Its inbuilt in excel only
Com add-ins select krne ke baad add ins ka option nahi aa rha
Which Excel version you are using
I know this but the problem is when we have different structure..
In that case we need to check manually only...one question to you..why we need to compare 2 different structure data..??
@@GyanOnTube sir there are many times in financial sector when the 1 data set in excel contains extra rows and this creates line items to be mismatched. Your way compares cell by cell and row by row value but what if 1 line is in first row of one excel and other is in last row of 2nd Excel.
but missing values ko kese fill krenge?
Kaunsi missing value
@@GyanOnTube sheet 2 values jo sheet 1 ma missing hain. aap ne jnko highlight kia hai. unko sheet 1 ma kese dale ge?
Sir mere option nhi aa raha he aisa q
Kya aap office 365 use kar rahe ho
I dont mere company ne allot kiya he mujhe usme bank reconciliation karna padta he mujhe aur na look-up kam karta na kyuki usme unique values nahi hote bhut se tranjection duplicate hote he aap mujhe batao me kese isko slove karu please sir
Remove duplicate kar do
Encourage nahi a raha
Which excel version you are using
Try kiya but nhi huwa sir
Kya kuch error aa raha hai
SIR EK ISSUE RA HAI
Hanji bataiye