use common record in "Completed Records Comparison (File 3 vs File 2)" result, check total number of the column "M5" not equal to "Y", and allow to download the excel to cross check
count file 3 column "M5" with value "Y", then compare the column "CNA" with file 2 "EMAIL", to count how many is unique to file 3 (CNA), common record in both file, and unique to file 2 (email)
compare file 3 column "CNA" with file 2 column "EMAIL", to count how many completed are unique to file 3 (CNA), common records in both file 2 and file 3, and unique to file 2 (email)
i need to upload a file 3, please remove those row whose department is started with "THEI", and then get the number of "completed" and "not completed" in "M1 Status" column
