Is there a function or formula that will automatically filter repeats out of
a list? If I have account numbers in column A, and some of them are
repeated, I want the account numbers in column B without repeats. I can use
advanced filter but I wanted a functional way that will automatically update
when I update column A.

If I have three copies of a workbook on three different drives, is there a
way to make changes to one that will automatically update the other two
copies?

Thanks!