How to Compare Two Excel Sheets and Find Differences

[@Jaime-c9l]

I can't tell you how many videos I've watched on this subject - FINALLY clicked with your help - thank you!

[@shibingeorge89]

This was the simplest and most useful video about how to do this. Helped me a lot last night. Thank you, AlFan!

[@unlockcapacities7992]

This will only work if the items are matching each line wise. If in feb-21 there is one missing line, all the subsequent values will show difference, but actually it could be mating.

[@austinpowers1999]

and could be matching

[@arthipannerselvam3752]

Yes finally what's the solution

[@kevfletcher1]

Thank you for this, very simple.

[@sat4kum]

Wow ! Helped a lot. Thanks

[@adeelsiddiqi6211]

Love it! Just saved me a lot of time!

[@user_Youtube4569]

Awesome bro. i knew the Formula but i was implementing it wrong but after watching your video now , it's now on my fingertips. Thanks a lot, Bro.

[@bars945]

can u help me with this one? I'm trying to follow the formula but I cannot find the symbol of 'not equal sign' ≠ only this one that exist in 2007 version. I kept receiving the same error message "You cannot use references to other worksheets or workbooks for Conditional Formatting criteria" I hope u notice this one

[@user_Youtube4569]

@@bars945 Try this " " the meaning of these arrows mean the difference or you can say not equal.

[@brentb3801]

Good, helpful video. Thank you!

[@prabur4027]

Very short and precise.. Thanks

[@wxmyjnsn]

I have a twist that I need help with. Like your example I have two sheets. Mine are names. One sheet is monthly users. The other sheet is a list for the year. I want the monthly sheet to highlight names that are not on the yearly sheet. Obviously the data is not the same size on yearly sheet. When I try the method shown in this video it only works on part of the list. Can you help me?

[@rimaal-homady7867]

You are brilliant and your explanation is soo clear

[@rowscolumnsbyalfan5936]

Thanks a lot 😊

[@oulafatla8686]

Thank you handsome for sharing the video

[@harleyasv]

How can I format it if I want to allow a difference of e.g. 5%, but mark the cell if the difference is larger than that?

[@webdesignermania]

Grate Brother... Thanks

[@shitalramtekeloa]

What if the value iin the rows are not exactly on the same row? I mean Engine Fan in first sheet is placed on R15. How to compare if Engine Fan is placed at R14 in second sheet?

[@bamideleayodele736]

Can someone help with the formula? It's not clear

[@greeshmavivek8226]

The formula is not clearly visible. Can someone paste formula here.

[@learnertrader3801]

it is not working with earlier version?

[@rowscolumnsbyalfan5936]

Which excel version are you using?

[@learnertrader3801]

@@rowscolumnsbyalfan5936 2003 version

[@faiyazahmad311]

Super, thank you very much. It helped me.

[@harinibalasubramaniyan3551]

Very useful thankyou so much😊

[@phungvanminh9880]

Thank you so much.

[@timkline162]

Is there a way that I could create a sheet that has a huge master list of customers on sheet 1, and then sheet 2 would have a list of customers who made a purchase or some other activity, and then sheet 3 would basically copy all of the people listed on sheet 1, but remove anyone that was on sheet 2, and sheet 3 would just show me the final results?

[@AlllAboutYou]

I can't see the formula due to video quality (should have enlarged it) that you typed in (did you removed only the '$' sign by pressing F4?) I'm using a laptop so it's not the same :(

[@sharathkumar9405]

FN+F4

[@perampatibhavana4200]

What is FN

[@harshify_13]

​@@perampatibhavana4200functions key

[@omakintolu5108]

Great! Thanks very much.

[@AnneesUrRehman]

I can't find not equal sign here, help?

[@santhoshbpillai6679]

Informative

[@rowscolumnsbyalfan5936]

Thank you😊

[@harismalik6601]

Bro you savey life

[@vinithamurugesan7684]

which key pressed in remove dollers

[@gyratingseacow595]

F4

[@nadaamr3507]

How to apply it for text.

[@swatichauhan4835]

The error is because of excel version 2007?

[@mrkanjirappally6153]

Useful

[@swatichauhan4835]

Izts showing sone error ' refrencing cant be done from different sheets'

[@PunjabiCowboys]

Thanks but your tutorial video is blurry, hard to see the actual characters. Please try to speak little slow, you are talking super fast. Its hard to follow and understand.

[@នាទីកំសាន្តរម្មណ៍ផ្លែកៗ]

❤ thank you 🙏 ❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@AhmadFerdaws-f2q]

It didn't work for me, I don't know what is the reason?

[@Spaceballs30]

Bro: this is great but you gotta slow down just a smidge when you get to the "not equal" part of the video. I had to pause it multiple times just to follow

[@asdfghjk7775]

Thanks

[@rowscolumnsbyalfan5936]

😊

[@pommel1779]

i followed exactly and it does not work, the formula only applies to one cell

[@priyashukla5810]

I typed F4 three times but the dollar sign not disappearing Can someone pls help

[@isackowano5398]

Someone help please im experiencing the same problem

[@srinivasankaliyaperumal9176]

@@isackowano5398 remove it manually

[@monalishapatel3693]

Same for me as well have u found any solution

[@shab5991]

Press fn + F4

[@Jyo0809]

fn+esc+f4 will work

[@angelabebo25]

smart yong man

[@garylillich]

Please add USING CONDITIONAL FORMATTING to title

[@piyushpatidar6481]

thanks

[@cherryanneimperial1639]

Press F4?

[@likhithakande2902]

If it does not work then press fn+f4 to work

[@Pavanibhargavi05]

F4 is not working

[@pavanharshauppala3730]

Use fn + f4

[@muhammadfahimi2919]

TQ

[@suhailnottithodi5648]

👍👍👍

[@rowscolumnsbyalfan5936]

😊

[@arkichannel0119]

those are not 2 different excel files, that is only one with 2 sheets!😅

[@rajendradhami-n1m]

cool

[@andrzejtymotenko6237]

Bad quality, the formula should be in the movie description

[@TONY_FEZ]

Would be great if you didn't talk so fast - thanks though.