Sort the data file by Prior Year Aud Key and delete all the observations with #N/A in the Prior Year Aud Key column. Next, using the IF,THEN statement in excel, determine which companies changed auditors from 2016 to 2017. Designate this column as CHANGERS or NOCHANGERS. This should all be done in the newly created tab.
Solved by D. B. in 20 mins