Thank you bosco_yip
Referring to Sheet B, as this is the first one I need to do
In total we have 65 positions, and some employees can have up to 5 positions / responsibilities
a. The formula supplied only works to a max of 2 position per employee, and up to 9 positions. Is it possible to update it to accommodate the additional parameters?