Bank Reconciliation in Excel without a reference or Key

Learn how to break down complex reconciliation tasks into small bite-sized chunks, then use various Excel formulas and functions to solve each chunk before finally putting the pieces together like a lego to create an elegant Mega formula solution, saving you hours/days of frustration.
Reconciliation master class, Array formulas, SEARCH Function, INDEX Function, MATCH Function, ISNUMBER function.

[@Manel_Disney]

fantastic!

[@SudhanshuRijal]

This is so much helpful. Keep up the good work. Thanks.

[@GreedisGood83]

Great video, at first I didn't know where you were going with this. But soon I saw the intelligent way that you explained each formula, why it returned an error, and how we could fix it. Video is full of great knowledge. Thanks especially for the sole purpose of the video "Recon without a reference or key." Keep up the good work, and keep it coming.

[@davidbrown2204]

Thanks Justin, very much appreciated. We will be loading much more here. Also, check out our new e-learning academy on www.officetraininghub.com

[@LOSURFNDANCE]

Thank you so much, very helpful. You explain very well

[@husnainmalik2108]

great...searching for long..thnk u

[@duoning]

Thanks for the video.

[@RJSivakumar]

Cool video

[@foliadexogunmodede5800]

Nice one

[@aasishkumar267]

Sir. Good day, thank you for uploading videos. Is it possible to reconcile without reference key in power query or power bi or is there any other way to reconcile without using many formulas? Will be really grateful for the solution

[@ETOEstate]

Very good instruction. You have some audio blackout around 8:24. I will have to watch this again later. Thank you.

[@davidbrown2204]

Thanks for your comments. I didn't experience the blackout. At that moment I mentioned the fact that you can only enter an array formula with Ctrl+Shift+Enter. Array formulas are popularly called CSE Formulas.

[@TheMoonLitGirl]

can we use the flash fill function for this?

[@00indraable]

Finally i got the result...the weird thing I have to press F2 then F9 button to get the result as the value and the formula is off, is there any steps that I miss?

[@willm7994]

Hey DB is it possible to add the spreadsheet to the tutorial? Please

[@badboytomas]

you are still only matching using a unique key provided by the bank that stays constant, how about reference that is continually changing for the same customer account??? instead of an account number that the bank provided (which not all banks do) my bank provides a 6 digit numbers counting up by one each time there is a transaction placed on the excel statement I have.

[@judeokolo299]

I have used this formula so many times, it works sometimes and the other times it fails

[@AKELLA567]

Sir, You made an impossible to possible.