Hello.

I am trying to create a list with only unique data from another set of data. I know this would be simple using AutoFilter, but I need it to be a formula.

Column A:
AAA
BBB
CCC
AAA
AAA
CCC
BBB
DDD
DDD
FFF

I need Column B to look like this:
AAA
BBB
CCC
DDD
FFF

Column A is a live data, so the range will continue to increase. Ideally, I would like for this formula to apply to the end of the data list automatically (so that I don't have to fix the formula every time new data is input), but if this is difficult I can live with assigning a random row number, such as 1000.

Would truly appreciate your help. Thanks in advance!