I will have a spreadseet that is approximately 3,000 rows. In Column A, the
user will be entering an account number . There might be 100 unique account
numbers.

I am looking for either a formula or a macro that will automatically display
the unique account numbers as they are being entered. So in this example I
would want the unigue account numbers to be listed begining on say row 3010