One instance of each value within a text range

Originally Posted by oeldere

What about my solution in #6.

Whilst it works, it depends on three helper columns which when applying this to my actual workbook and not the test sheet I attached, I need to avoid the use of helper columns.

Have made note of your solution though for future reference so thank you.