Formula for removind duplicates without using 'remove duplicates' button

Hi there1

is there a formula that allows me to automatically remove duplicate values in a column in excel?

Let's say i have column A which contains a list of web addresses. I need a formula that will enable me to display in column B all the unique web addresses and leave out the duplicates. i cannot use the "remove duplicates' function in excel for this as the data in column A will be changing from time to time.

I really hope someone can help me with this! Many thanks in advance!

best regards,
Aaron