Hi. You helped me resolve my issue. None of these directly resolved it but at 7 minutes, I took a closer look at the group. I hit "Show Formulas". I saw that one of my dates was not reporting correctly. Updated and formula calculated correctly. I have been held back for 72 hours prior. So, you can add "Show Formulas" as a way to investigate issues. Thanks!
Useful video! In our work, data in column A to D are often provided by third parties and we cannot alter them, or even if we change them, they will repeat the same problem in the next batch. So our solutions are focused on how to change the column G inputs in order to get the right answer.
Hi. You helped me resolve my issue. None of these directly resolved it but at 7 minutes, I took a closer look at the group. I hit "Show Formulas". I saw that one of my dates was not reporting correctly. Updated and formula calculated correctly. I have been held back for 72 hours prior. So, you can add "Show Formulas" as a way to investigate issues. Thanks!
You solved it, that’s all that matters 😂
Thank you Mark. A video that solves many day-to-day problems.
Thanks Ivan
Useful video! In our work, data in column A to D are often provided by third parties and we cannot alter them, or even if we change them, they will repeat the same problem in the next batch. So our solutions are focused on how to change the column G inputs in order to get the right answer.
You need to look at Power Query. Then you can automate the entire process down to a click.
Thank you, this video is very effective:)
Glad it was helpful!
Thanks so much Mark!!!
My pleasure!
Thanks Mark!
My pleasure!