Excel Tutorial to Quickly Reconcile two sets of Data
ฝัง
- เผยแพร่เมื่อ 7 ก.ย. 2024
- An Easy Excel Tutorial to Quickly Reconcile data.
🔶 Get the Practice Excel File Here : bit.ly/3g362go 🔶
Digital Products:
🔷 gumroad.com/te... 🔷
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/Te...
Follow me on below to stay connected👇
👉FaceBook: / teknisha
👉Instagram: / teknisha18
Nice video. Shows how you can use Excel quickly and simply without getting bogged down in more complex LOOKUP functions. Thanks for posting!
Same feeling here... 👍
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
Wonderful
Very simple and straight to the point, Thank you!
Extremely helpful ! Thank you very much 10/10
Glad to hear it!
Thank you, very clear explanation.
Glad it was of help
Mind blowing.... No words for your talent
Thank you so much 😀
Thank you ,Sir.
I just loved your great talent and your brilliance.
Wow than u so much this is great. What if we had two criteria instead of just one?
Thank you, this was helpful and easy to follow.
Thank you for sharing. Very helpful! 😃
Thank you!
Your video is very helpful. Thank you.
Glad that it helped you…
Impressive technique
thanks!
You bet!
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
Great!
Glad it helped!!
Gd evening sir I am your new subscriber and your tutorial videos are very helpful for me please bear with my bad english 🙏🙏🙏
It's very ressourful !
Glad that this helped
Thank you
Do you know how to match name and amount to another name and amount that has duplicate transaction and sometimes same amount.
Thank you so much for this video! You help me a lot!
Very useful and to the point video!
Happy that this tutorial helped
Amazing amazing soooo much helpful
Glad that this helped you…
@@TEKNISHA I am a banker.n this video is life saving for me
I am so happy… makes all my effort worthwhile
Awesome thank you man!!
Thanks. :)
Glad that this helped you
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??
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
Nice video, thank you for making it. 👍
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?
Nice video 👍
Thanks 👍
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???
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.
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?
Hi, instead of 0,1 is it possible to reflect as True / False instead since I do not intend to hide the columns.
=IF(COUNTIF(range, criteria)>0,"TRUE","FALSE")
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?
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?
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.
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!
Sort then =if(A=B,"yes","no"). Does this work ?
yes. can work too
Hello Sir, Very Helpful Video, would you make a video for vlookup
Glad that it helped. I have already made a video for vlookup. th-cam.com/video/YVQf_fvImPE/w-d-xo.html
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!
It's so easy! Thank you!
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 ?
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)
How can I reconciliation to stock market
Gentle Request: How to get "exact cell number" for matches or differences?
S
way too fast and the transition from deleting cells, to undoing and deleting and adding wasn't explained on how.
Hello Alisha, thank you for the feedback. undoing can be done using keyboard shortcuts. “ctrl+z” (for PC) or “CMD+z” (for Mac).
Too fast🤔