In Excel, dates are just numbers. Whole numbers. In the video, because they are part of the formula, they are part of the comparison. Date / Time combinations would be more challenging, as they are decimals. In this case, try an Integer function to group them by day. Or, group them by day within the pivot table.
Hi Suban, Here is a link to the file. You should be able to download and save it. docs.google.com/spreadsheets/d/1OtAO28czd19pTwCEaGV8PaoaU3LG4Cqk/edit?usp=sharing&ouid=112934880298982104184&rtpof=true&sd=true
Hi. I am using the concatenation operator to combine the contents of columns C, D and E. Enter this formula into B7 and copy all the down. =+C7&"-"&D7&"-"&E7
I want to thank you from the bottom of my heart! I’ve been trying to do a rec with TONS of information. This saved my life. Thank you!
i lost my job because i do not know this excel skill
Thank you for the clear instructions, made my life so much easier at work today!
Wow This is such a simple , clear and creative way of reconciliation! Thanks!
Amazing data saved my life :)
a quick question how do you deal with slight differences in the 2 sheets such as dates
In Excel, dates are just numbers. Whole numbers. In the video, because they are part of the formula, they are part of the comparison. Date / Time combinations would be more challenging, as they are decimals. In this case, try an Integer function to group them by day. Or, group them by day within the pivot table.
Wonderful explanation,randy . Can you explain me how to automate this using Macros.
Thank you 🙏🙏
Can you please provide excel file for practice?
Hi Suban, Here is a link to the file. You should be able to download and save it.
docs.google.com/spreadsheets/d/1OtAO28czd19pTwCEaGV8PaoaU3LG4Cqk/edit?usp=sharing&ouid=112934880298982104184&rtpof=true&sd=true
@@AZAdvancedAnalytics Thank you
This video is made with such big zoom out that it harrdly makes any sence to watch it
Can you type the formula here? You’re going to fast
Hi. I am using the concatenation operator to combine the contents of columns C, D and E. Enter this formula into B7 and copy all the down. =+C7&"-"&D7&"-"&E7
@@AZAdvancedAnalytics thanks