I show in the attached file my input data. My desired output in Column B, which I need a formula to get too. However I cant think of a formula that would achieve this!
In Column C I have shown the formula I have attempted, but as you can see it doesnt quite work.
File attached. Thanks so much
DaveHelp!!!.xlsx
Bookmarks