I have a spreadsheet with about 6,000 rows of data in three columns:
Column A: Deparnment name.
Column B: Name of the employee.
Column C: Total expense for training.
The spreadsheet lists employees in multiple rows. For example, if John Smith recieved training on three different occasions, there would be three separate rows for him. I am trying to find the total number of employees for each department without double counting the employees. Is there some sort of excel formula I could use to do this? An IF statement maybe?
I've already sorted by department and by name, but that's as far as I've got.
Thank you for the help.
Copy Column B and Paste it in a blank column of Sheet 2. Then remove duplicates using the Remove Duplicates Option. You will get the unique list of employees. You can get the count by using =counta("A:A") in a blank cell.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thank you, I appreciate it. That was very helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks