Forum Discussion
Comparing and retrieving locations NOT visited using two excel docs
I have two excel docs; one is a schedule of locations to visit on certain days. The other is an exported report that shows visits made by day. I need to be able to not just compare the report against...
Thanks SergeiBaklan ! Unfortunately, here at work we are on Excel 2010 without Power Query add on...Unfortunately I am thinking this may have to be some formula work or perhaps reorganizing the exported reports. I could be wrong though..
Perhaps that could be formulas, Power Query is just more natural way these days. To suggest something concrete with formulas it will be better if you submit small sample file(s) without any sensitive information.