An easy way to see which worker is availble

**gartye** · 09-19-2016, 10:12 AM

Hi
I have a large table of my workers and their tasks. Everyday I distribute tasks between my workers (~50) and mark who finished what. My table has three relevant columns: name of task, worker assigned and if it is finished or not. I would like to have a simple way to see how many tasks every worker is working on in every given moment. Is there any way that excel will look through the list of tasks and summarize it for me in one simple table?
Thanks
Erez

**Bglamb** · 09-19-2016, 10:23 AM

Can you upload a copy of your data so we can see what we're working with?

**gartye** · 09-20-2016, 02:18 AM

Here is a small sample part of my excel (i removed irrelevant columns to make things easier
https://docs.google.com/spreadsheets...it?usp=sharing

Thanks
Erez

**Bglamb** · 09-20-2016, 11:12 AM

Hi Erez,

This is fairly simple.

Make a column to the right entitled "this task is currently being worked on by ..." with the forumla

Please Login or Register  to view this content.

This will display a list of names for each task that is currently being worked on, and who by. It checks if the state of the task is 'working' and if so, it outputs the name.

Else where you can then count the occurrences of a name in that list with the formula

Please Login or Register  to view this content.

This will output the number of jobs that "JOHN" is currently working on. It looks through the whole list we've just created (D2:D18) and counts the number of times the given string ("JOHN") appears. Repeat for each member of staff.

Let me know if any of this doesn't make sense and I can upload a sheet for you.