I got it to work.  Thank you so much!  I had some references backwards.

Thank you for your code.  I tried it but I was am getting an error with Distinct_Department_Count.  I am getting an invalid table name error.

Sorry for the confusion. Yes, as the data stands right now the entire column should be populated with an *. If the department column included 0001 and 0002, then Export...