Hello All,
Please see the attached spreadsheet... "Data-EmployeeStatus" i've had to empty a number of fields to confidenuality but generally you can get teh idea that I'm training people's EmployeeID numbers by department. As we add new people they will be assigned different departments and their status will become active (and departed when they leave).
"Department Summary" is what i want to do. I did the first ACC by hand but i'm looking to pull from the "Data-EmployeeStatus" sheet all the information horizontally; with the critia that it only be active people and to display just their unique EmployeeID number.
I think this will need to be an ARRAY forumla but prefer it not be.
Thanks in advance for all your help!
Bookmarks