Context...
I'm working with a very large file but I will simplify it with the following:
I have static data in columns a through d (static datal and look up formulas in columns H through H fetching data from a report (report data). The static and report data should reconcile one for one. Columns I through L contain a true or false statement to validate the first two sets of columns respectively.
Objective...
My goal is to investigate unmatched records in related columns. E.g., the rows of data in column E and column A that are not the same
I'd like to accomplish this with a summarized table view with a bulk count where records are unmatched. I know I can do this using count if however I was hoping to use a pivot table to facilitate my next goal
Furthermore considering this is across several columns I like to drill down and see the unmatched data from the paired columns.
I'm working with a very large file but I will simplify it with the following:
I have static data in columns a through d (static datal and look up formulas in columns H through H fetching data from a report (report data). The static and report data should reconcile one for one. Columns I through L contain a true or false statement to validate the first two sets of columns respectively.
Objective...
My goal is to investigate unmatched records in related columns. E.g., the rows of data in column E and column A that are not the same
I'd like to accomplish this with a summarized table view with a bulk count where records are unmatched. I know I can do this using count if however I was hoping to use a pivot table to facilitate my next goal
Furthermore considering this is across several columns I like to drill down and see the unmatched data from the paired columns.