MS Excel - Compare Two Sheets 

To Get Certification, Click Here: bit.ly/38Jyu3p Use coupon "RU-vid12" to get ‘’FLAT 12%’’ OFF at Checkout.

Check out latest MS Excel Online Training courses on : bit.ly/38Jyu3p Use coupon "RU-vid" to get FLAT 10% OFF"

BUHAT ACHA SAMJHAYA HAY SIR APNAY....VERY GOOD....I HAVE SEEN ALL YOUR VIDEOS...

Awesome presentation, is this done via a projector or touch screen tv? I want to do training for my kids and this is the best way to do presentations!

pawan i wanted to do a match analysis 2:1 data to find obvious factors and do i need two data reports to compare the match or are we able to do it same report report i created .need advice

Your teaching skills made it Just simple & awesome, much informative! Thank you.

Sir what if the data is large, and manually it won't be feasible to scroll and compare. please suggest. Thanks

Hi, can you show me how to find and highlight the difference in two tables?

Hello tutor guy, you're my bro man. Enjoying and learning very efficient stuff.

Sir while uploading a new lesson please include the file in the description area so that the viewers can practice it very easily.

The way explaining N teaching both R superb

How to install in our system, I'm profound of from very Start of my career of tutorial Point

Can we compare two specific coloumns??

Do we have any feature in Excel for comparing 2 sheets but data is little messy ? For eg I have to compare GSTR 2A with Tally Data entries and extract those entries which are in tally but not in 2A and vice vera Hope u get me ......

Dear Sir it is very nice presentation and I hope everyone can easily get basics MS- Excel.

I HAVE TWO ARRAYS THAT CONTAIN NUMBERS THAT RANGE FROM 1 TO 30 AND I ASK EXCEL TO LIST THE TRIPLE AMONG THESE NUMBERS THAT ARE SIDE BY SIDE IN EACH OF THESE TWO ARRAYS FROM LEFT TO RIGHT UP AND DOWN AND LIST THEM WRITE WHICH FORMULA SHOULD I USE HELP ME PLEASE

you are superr, and amazing excelling tips, keep posting more excel videos, Thank You

Excellent teacher

Thanks for explaining dear, sir, my excel 2013 shows the view side by side greyed out and it does not do anything when I try using "arrange all- Vertical" - would you please let me know how to fix this. You are doing an excellent job of explaining to us - pl keep it up and stay encouraged - THANK YOU SO MUCH FOR HELPING !

@tutorials point India sir please tell what is the shortcut key for comparing two formula within the same sheet.

Excellent work, I could brush it up all and could gain a lot advanced knowledge ..A request from my side, There are a lot of short cuts in most of the episodes which might get easily forgotten as the students go ahead, so make a separate video includes all the important short cuts and formula, Thanks in Advance..

If I have some values in one column 0.0, 0.81, 1.25, 2.50, 3.50 but we want print to other column 0 to 0.5 through if condition so plz suggest formula sir ji or any guys

01:24 actually superb sir.. am really understood

HI need yur advise please. on one sheet I have a set of email ids - tagged as "did not accept my invite yet" and on another sheet I have the same set of email ids - identical email ids with contact nos. I want that the contact nos. match with those email ids - who are yet to accept my invite so that I can call them to remind them to accept my invite. I dont want to go the long way where I copy that email id go to the sheet where the contact nos. are click ctrl find then paste - not used to that type of hard work. Pls help. thanks

Hello I have below query, How shell i do color scale conditional formatting in entire table formatted raw by every alternative column. Also any future raw or column to be added the it also should take similar formatting in auto mode. Thanking you in advance. Regards Bharat

Hi, what are you using in the background?

Very informative videos.❤ From Pakistan

Your presentation skills are good

Very very clean presentation ..

Good one .... there is a method to compare two sheets and delete duplicate whole line w:r: to second sheet ???

Hi sir, your explanation is very good, keep it up

It is very easy and simple sir.

Sir excel me vlookup ka aisa formula btao ki search krne pr result nikl ke aaye chahe value ke aage piche kuch likh rha ho means formula upne aap sheet me value ko dundke result de de.

You Are So Nice. Always Provide A Informative Video. That’s why I like Your Channel Thank You so Much...

Awesome teaching

Hi I have a question, how to compare multiple rows that contains multiple combinations of columns. For example, row 1: A1="a,b" A2= "c,d" A3="e,f" row 2: B1="a,f" " B2="c,b" B3="e,d" Now I want to see a result that says both rows are match or the same since they contain all the elements a,b,c,d,e,f. I hope for your response. Thank you.

How do you make videos? Please tell.

Hi sir, please explain how compare and find duplicates in 2 worksheets

I like ur way of speech.... 👍👍

Thank you so much. Your videos are really helpful.

Good Morning sir, I want to know "AverageA" function please give me any video refrence please

Sir, now I have two data's one consist of barcode data of machinery before scanning and another is barcode data of machinery after scanning But my doubt is after scanning through scanner I have dropped all data's to excel. so I need sort with one n second scanned data through formula First Data has some unscanned barcode details

Teaching is clear

Thank you very much, it made my work very simpler

Please how to link the two worksheet with different column name

That was extremely helpful sir! Huge respect for your videos.

Sir u teach very well.... Really nice Sir...... 👌

Very Informative

Thanks!! It's helpful :)

I have some data in sheet no 1a column I open sheet no 2 this time I enter in b column some word in releted to sheet no1 column a this time that Total word I need how is possible ( ex we have already enter some names in top when we again enter in down same character 2or 3 that name will be automatically comes right but this time I need same but the data is not in the top it is another sheet any formula are steps available please tag me)thank you

your vidéos are great

Thankyou sir

Excellent Sir

Sir your teaching way is so easy.but I request you sir. make some videos for example.

One entered in material name, I have different price for different material (Ex. MS, SS), I need calculate the material cost for one column both materials, is it possible

Really Appreciate you

Thank You So Much Brother. It is very much helpful.

Side by side will just help manual comparing easy

Please explain how to maintain Housing society monthly subscription receipts in Excell sheet.

Amazing vedio

Great sir... Way of teaching is amazing...

Thank you sir 😊

Thank you for your teaching. Hats off to you bro. You make others life easy.

Thx u Soo much sir

Thanks 👍 superb

Thank you😊

Good one....

Lot of thanks sir ..

waooooooo sir love the way you teach

Sir aap bOhOt achhe ho❤️

Amazing pawan sir

I am not getting. How we come to know comparison between two sheets and mismatch is there.

Sir, I need some help from you... I want to customer invoice matching with his payment amount... But I want key data only one sheet it will auto effect customer wise ....can you help me

Very nice bhai

i like u r way of talk

Sir Can u help me to prepare yearly salary certificate. I can prepare it monthly by using mail merge.

Sir Ms Word mai agr long text ho to...or wo mujhe bar bar likhna hai...us text ke kuch letters lekr or Space button press krte hai to wo automatic type ho jaati ...wo kaise hoga?

Sir if I want to compare 2 different excel sheet same as u shown for same file. Plz help sir

How to vlookup between two separate version ms office

thank you so much.

Give me tips to making timesheets easily

Wonderful that the way of explaining.. Thank you sir.

I want to update entry for live data.how can do it?

To be appreciated...as it is so clear to understand...

Well explained..!!!

Sir how can I identify from a excel date sheet some data are updated and some data are not updated. How I separated them.please sir give me the.solution

how to count decimal amounts in one coloumn ie 12.5 ,13.5

Thank you

You are just fabulous, guy

awaiting for your new videos

Thanks

Nice

what screen is it.... i mean is it a digital board or something

Sir, great information

Sir, by default Sync scrolling is not selected so what should I do then?

THANK YOU👌👌👌👌👌👌👌👌👌👌👌👌👌👌👏👏👏👏👏👏

helo sir, I want to compare two column in excel having alphanumeric cell, kindly guide as early as possible.....thanking you

Thanks❤

Sir teach me how to do vlookup in a single file with different sheet ....

How to calculate f.p.s unite. Such as 2'-6"*4'-3"*5'-10"