Listing free workers from Workers Assignment table

[amitc4u]

Hi,
I have Workers assigned to projects by type of the worker ('Workers assignments sheet').
I would like to assign the workers in the "workers Assignment" sheet and I want the "Free Workers Table" to be filled automatically by the names of the workers in the "workers Assignment" sheet that are not assigned to any project.
in the attached file there is an example of how the two tables look like (after it was updated manually).
The assignment will be in the Workers table and the reflection will be in the Free Workers table.
Thanks,
Amit

 

[Somendra Misra]

Hi,

See the file.

Regards,

 

[amitc4u]

Hi,
It works great and it's very helpfull so again thanks a lot.
now I'm trying to creat an upper line that counts the free workers in each month.
the function 'CountA' doesn't work because the cell isn't realy empty, it contains the formula.
Do you have a simple solution?
see the yellow lines in the attached file.
Thanks

 

[amitc4u]

Hi,
forget about the last message, I did '=COUNTA(C5:C30)-COUNTBLANK(C5:C30)' and it worked.
tell me please, when I try to edit the formula (replacing the sheet name or any other changes) the signs {} disapear from the formula and it doesn't work.
how can I eddit the formula to other sheets and cells?

 

[Khalid NGO]

Hi,
forget about the last message, I did '=COUNTA(C5:C30)-COUNTBLANK(C5:C30)' and it worked.
tell me please, when I try to edit the formula (replacing the sheet name or any other changes) the signs {} disapear from the formula and it doesn't work.
how can I eddit the formula to other sheets and cells?

Hi,
Seems like you've press just enter.

{} means this is an array formula, which must be entered with Ctrl+Shift+Enter (not just enter)

 

[amitc4u]

Thanks a lot, works perfectly.