If you have tried both of the solutions offered in the workbook in Post #7, and neither work for you, and that is why you are trying another formula that doesn't work for either you or me.

You would do best to post a sample workbook showing your data types and sheet/workbook layout/structure.

It should clearly illustrate your problem and not contain any sensitive data.

Cheers