Hi everyone!
I am really desperately in need of help from you excel gurus. Have been searching through the web/forums for a solution but it has been in vain.
I have basically new tasks everyday up to around 100. I have a list of employees, example 20. However they have different skill sets. I would like to allocate them with tasks equally and according to their skills set.
Attached is the sample excel ( the raw data as well as my intended outcome ).
Greatly appreciate the help from you guys! It can be either using vba or formulas
sample book.xlsx
Bookmarks