Thanks for the reply. I have done that but it does not solve the problem...

When I copy or duplicate B2 cell to other cells, it will not work as it should. Once I select eg. Salary on B2, all the other cells can only select Salary and nothing more.

Looking at it again, I think it's because column D cells are with this formula =IF(ISNUMBER(SEARCH($B$2,E2)),MAX($D$1:D1)+1,0)

Hence, may I ask how do I tweak the formula so that B2 cell can be replicate to work when copied to other cells?

Thanks.