Comparing 2 spreadsheets with same column headers

[joewils92]

Hi,

I'm trying to compare two spreadsheets to determine and collate entries where fields have changed for e.g 'Status' has changed from pending to settled, if theres any new entries or dropouts, or if the value has changed. This is a monthly exported spreadsheet process which shows everything in there to date for each claim and is rolled over monthly which is where i have trouble analysing whats happened in that month.

I wasnt sure how best to analyse this but i was thinking maybe multiple spreadsheets in the same file that show the differences.

Any ideas would be really appreciated! 

Thanks

Joe 

[joewils92]

Hi,

I'm trying to compare two spreadsheets to determine and collate entries where fields have changed for e.g 'Status' has changed from pending to settled, if theres any new entries or dropouts, or if the value has changed. This is a monthly exported spreadsheet process which shows everything in there to date for each claim and is rolled over monthly which is where i have trouble analysing whats happened in that month.

I wasnt sure how best to analyse this but i was thinking maybe multiple spreadsheets in the same file that show the differences.

Any ideas would be really appreciated! 

Thanks

Joe 

[alexnajm · Accepted solution]

Here's a start - I would look at combining the data together with a Label created, Transpose the metrics you want to compare, and Crosstab the metric back but on the new label. If there's a different level of comparison, you can change around the Transpose/Crosstab configurations.

Good luck!

[joewils92]

Thanks very much this look is great! I'll have a play around but definitely looks like what i was trying to achieve.

much appreciated!

Joe