By using t2do.com you agree to our
cookie policy
, We and our partners operate globally and use cookies, for multiple purposes
Close
Data Verification - Compare 2 files Month-over-Month to see differences
Open the two spreadsheets
Count the number of used cells in each
Count the number of rows and columns in each
Check if file has the same number of fields
Check the totals of each column
Check unique record counts
Check max/minimum/average/std dev/etc
Check other statistics (ex. benfords law;randomness;streak analysis)
Check if files are the same
Create the output data within file
Find where there may be issues
Drill-down to find causes
Open a new spreadsheet
File system and folders
Set up Developer tab
Save it as .xlsm file
Levels of difficulty
one sheet per file
Hard coded file entry
Run Button on sheet
Output in same file
Medium
Basic Error handling
Output in new file
Advanced
Service that accepts 2 files are returns the differences