Updated HELP.xlsxHi, that is very close to what I wanted. Although it doesn't seem to produce the expected results?
Would really appreciate if you could have a look at column E.

Also if its not too much trouble I would love to learn how your formula works.