Hello,
I am comparing data from two versions of the same report to identify the differences so I know which records have columns that need to be corrected. I am using a Formula tool with eight expressions to validate four sets of data and arrange the output messages. This solution works but I have two questions.
Solved! Go to Solution.
hi,
you can transpose the data and then compare a single column - i think it is quicker (my solution attached).
Thank you @JarekSkudrzyk! This approach worked perfectly.
@EricMartinson you are welcome, glad I could help!