By using t2do.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

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