OP believes that a VBA solution would be faster than the formula solutions offered. File with formulas applied is in post #3. A faster formula is posted in post #5. Would appreciate a VBA coder taking a look and offering the OP an opinion/solution.
https://www.excelforum.com/excel-pro...ml#post4991691