Employee Allocation - Excel IF & Variable Formulas

good morning everybody

Unfortunately i had one post regarding a similar issue but i can't find it anymore, forgive me about that

I have created an excel file for employees allocation and movements, its almost done but for some reason am stuck again.
a special thank you to one member of this forum for helping me out earlier

i have posted my excel file along with some screen shots of what am trying to do.

do you guys think it can be done in excel?

if its not clear please let me know

thank you all again for your help!!! it is very much appreciated

luca

Hi Skynet,

Suggest you to change the thread title to reflect the query being asked... see the forum rules:-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

In Column E for gender use..

Please Login or Register  to view this content.

In Column P

Please Login or Register  to view this content.

In COlumn Q

Please Login or Register  to view this content.

In Column R

Please Login or Register  to view this content.

In Column S

Please Login or Register  to view this content.

Increase highlighted protion of formula for subsequent beds

See attached

Check for the original 'Conditional formatting' (CF) that you had built in. It referred to Column Q.

If you don't need the CF, you can do away with it.

I dont quite understand what your CF rules are doing.

How would a number in Column F/H/J/K/L/M ever equal to the name that is upadted in columns Q or S? What are you trying to do with the CF?