monthly data discrepancies
 

I do a monthly revenue report; salespeople are paid monthly by Customer ID.
New month's data is added/imported from a text file. I do a report of new
month "customer ID's added" and "customer ID's dropped". Presently I sort by
customer ID and bill month and do this visually. Does anyone know how I can
have excel do this process .