Excel Tutorial to Quickly Reconcile two sets of Data

An Easy Excel Tutorial to Quickly Reconcile data.
🔶 Get the Practice Excel File Here : bit.ly/3g362go 🔶
Digital Products:
🔷 gumroad.com/teknisha 🔷
Check the below Playlists..
Excel Tutorials:
• TEKcel Series : Excel ...
Excel Chart Tutorials:
• TEKcel Chart Tutorials...
Excel Pivot Table Tutorials:
• Excel Complete Pivot T...
Excel Gsuite Tutorials:
• Gsuite Tutorials
Excel Tips & Tricks:
• TEKcel Tips : Excel Ti...
Powerpoint Tutorials:
• Tekpoint Series : Powe...
App Reviews: • Apps
Gadget Reviews:
• Gadget Reviews
Thanks for watching!!! 😊🙏
Please do Subscribe and Hit the Bell 🔔icon to support my efforts and to receive all my videos Notifications.
CLICK HERE TO SUBSCRIBE 👉 tinyurl.com/TeknishaSubscribe
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha18

[@funmigbokoyi6185]

Very simple and straight to the point, Thank you!

[@BruceKaufmann57]

Nice video. Shows how you can use Excel quickly and simply without getting bogged down in more complex LOOKUP functions. Thanks for posting!

[@indracanti75]

Same feeling here... 👍

[@robertue1]

Thank you, this was helpful and easy to follow.

[@pswdotarlacofficial9920]

Thank you so much for this video! You help me a lot!

[@WitchyGirl]

Thank you for sharing. Very helpful! 😃

[@RizwanKhan-zh6kc]

I just loved your great talent and your brilliance.

[@JuanLopezXVIII]

Awesome thank you man!!

[@marctemura2017]

Nice video, thank you for making it. 👍

[@joicecarinat.manuel4755]

Extremely helpful ! Thank you very much 10/10

[@TEKNISHA]

Glad to hear it!

[@joannahanasz5466]

Thank you, very clear explanation.

[@TEKNISHA]

Glad it was of help

[@user-xt4wr9ok9k]

a special thanks for u because one of my friend was given challenge regarding this reconciliation, i got the solution through this video thank you

[@TEKNISHA]

Wonderful

[@cindygarza339]

Great video! I was able to quickly identify the missing information. Can we add another step to also identify differences higher than $0.02 when comparing amounts?

[@rayyip0213]

Very useful and to the point video!

[@TEKNISHA]

Happy that this tutorial helped

[@toprider12345]

Mind blowing.... No words for your talent

[@TEKNISHA]

Thank you so much 😀

[@raidemukherjee9378]

Thank you ,Sir.

[@elpirulero]

Thank you!

[@mahmoudalshami1557]

But if there is reconciliation between our books and let say Creditor boos we have ti fill all of his information to reconcile am i right ? Correct me if I'm wrong

[@osfuentes]

Your video is very helpful. Thank you.

[@TEKNISHA]

Glad that it helped you…

[@carolm1719]

It's so easy! Thank you!

[@cynthiaamara2679]

Does it work on a structured table? Can I use it on different sheets of the same workbook in the case of a large data?

[@better8894]

Impressive technique

[@tigerlils3910]

Wow than u so much this is great. What if we had two criteria instead of just one?

[@salioucisse3504]

It's very ressourful !

[@TEKNISHA]

Glad that this helped

[@adnanade79]

Thank you its good but still i need more thing to solve my issue i also want to compare two column with two column so total 4 number of column to tally. Credit card unique number and amount of my ledger and i have to cheque with merchant credit card number unique number with amount. So do you know how to do that?

[@savithrivichhu967]

Gd evening sir I am your new subscriber and your tutorial videos are very helpful for me please bear with my bad english 🙏🙏🙏

[@jennykua4029]

Thank you

[@chauson8368]

Hi, can anyone help me explain why when I do countif, instead of showing 1 and 0 only, it shows 1,2,3,4,5. Thanks!

[@salmabasim1189]

Amazing amazing soooo much helpful

[@TEKNISHA]

Glad that this helped you…

[@salmabasim1189]

@@TEKNISHA I am a banker.n this video is life saving for me

[@TEKNISHA]

I am so happy… makes all my effort worthwhile

[@israelamach3733]

Great!

[@TEKNISHA]

Glad it helped!!

[@HussamQazi]

Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?

[@chyrsaberry]

Hi, instead of 0,1 is it possible to reflect as True / False instead since I do not intend to hide the columns.

[@pessimistic5579]

=IF(COUNTIF(range, criteria)>0,"TRUE","FALSE")

[@mohamedshiraz4671]

Thanks. :)

[@TEKNISHA]

Glad that this helped you

[@VK-ji6xm]

thanks!

[@TEKNISHA]

You bet!

[@nasirmurtaza143]

Nice video 👍

[@TEKNISHA]

Thanks 👍

[@amishashah9021]

what can be done if we have to criterias, like checking both reference no. and amount to know which entry is missing or not???? Can countif or countifs be used in such cases???

[@TEKNISHA]

Hi, it will be a Multi step process. You need to first make a helper column where you need to concatenate the reference no. and amount. Similarly in the other table too you need to make this helper column. And then you can use the count if formula shown in this method to check for the missing items in the helper column of both tables.

[@irynasavchenko91]

Thank you! May someone explain to me why do we need to freeze the range of Order Numbers here? I've only previously dealt with frozen individual cells, but it is the first time when I see the whole range gets frozen.

[@andrewburns722]

You don’t need to freeze, it’s actually called an absolute reference. By adding the $ signs before, you are telling the program to continue to reference that column or row!

[@vinayaka369]

Hi, it was very helpful thanks. However let's say 266 price has 1 lot in Table1 n 2 lot in Table2 how would u find out ?

[@TEKNISHA]

Great that this helped you. Reconciling should be done based on value only if it is unique, else you need use a unique identifier (like order number in this case)

[@ahmedgamer3082]

Hi, This is very useful, but I have one question. What if I want to filter data to view only cells that are not highlighted??

[@TEKNISHA]

You can filter using the helper column (1 for highlighted and 0 for not highlighted) , but you can do this only 1 table at a time

[@HaoNguyen-ee1ct]

Sort then =if(A=B,"yes","no"). Does this work ?

[@mohamedshiraz4671]

yes. can work too

[@udayranvirkar1896]

How can I reconciliation to stock market

[@sanjaydesai438]

Gentle Request: How to get "exact cell number" for matches or differences?

[@beaglesailor7531]

Hello Sir, Very Helpful Video, would you make a video for vlookup

[@TEKNISHA]

Glad that it helped. I have already made a video for vlookup. kzbin.info/www/bejne/j4e0l5Kcq66ghqc

[@patricklow8406]

S

[@mundangadan]

Too fast🤔

[@lifeinsideout]

way too fast and the transition from deleting cells, to undoing and deleting and adding wasn't explained on how.

[@TEKNISHA]

Hello Alisha, thank you for the feedback. undoing can be done using keyboard shortcuts. “ctrl+z” (for PC) or “CMD+z” (for Mac).