De-duplicate + print on the fly

[guy13]

Hi all,

I am looking for a forumla that I can paste into excel and it will lookup repeating text in A:A, dedup and print. The nearest I have got is =IFERROR(INDEX($A$10:$A$48,MATCH(0,COUNTIFS($E$9:E9,$A$10:$A$48),0)),"") however this does not work on the fly and it had to match up to the text exactly '$A$10:$A$48' not $A:$A

Please find the attached $$ for reference.

As always thank you for your time.