|Creating a list of unique account numbers can be done with the Data...Advanced filter feature.|
1 - Make sure A1 contains a column heading, not an account number.
2 - Data...Advanced Filter
3 - Choose: Copy to another location
4 - List range: $A:$A
5 - Copy to: $B$1
6 - Choose: Unique records only
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.