I am confused as to why you cannot simply use the "helper" column approach which does not rely on the order of, or content of , column B..

Column B can contain any text.

Perhaps post another file illustrating the "problem"..