for "M1 Status Summary", i want to count "completed", "not enrolled", "enrolled" from column "M1 Status", and also keep "Records Removed"

for "M1 Status Summary", i want to count "completed", "not enrolled", "enrolled" and "Records Removed"

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

use common records in "Completed Records Comparison (File 3 vs File 2)" result, count the column "First Module Date" by month

use "M5 (Y) Records Comparison (File 3 vs File 2)" common records, count the column "Completion Date" by month

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

initial commit