Simultaneous Filtering

M

Mike

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
 
M

Max

Mike said:
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
Click to expand...

Not sure what's happening here / what you're after, but why not just
autofilter directly on the account col? The autofilter droplist would
auto-display all 100 unique account numbers (limit is 1,000 uniques), and the
user could just select from the droplist? (No need to enter)
 
M

Max

Mike said:
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 unique account numbers to be listed begining on say row 3010
Click to expand...

Perhaps a re-take on the post ..

There's no account# col currently in the source table
and you're creating it now, in col A

Here's one play using non-array formulas ..

Assume source table is in Sheet1,
data in cols B to ?? from row2 down,
and the account#s are being filled in A2 down

In a new Sheet2 (better to do this in a new sheet),

Put in B2:
=IF(Sheet1!A2="","",IF(COUNTIF(Sheet1!$A$2:A2,Sheet1!A2)>1,"",ROW()))
Leave B1 empty

Copy B2 down to say B3100
(cover the max expected extent of inputs in Sheet1's col A)

Then put in A2:
=IF(ROW(A1)>COUNT(B:B),"",INDEX(Sheet1!A:A,MATCH(SMALL(B:B,ROW(A1)),B:B,0)))

Copy A2 down to say A200
(copy down by the smallest extent sufficient
to cover the max expected # of unique account#s)

Col A will auto-return the list of unique account#s neatly bunched at the top
as the list in col A in Sheet1 is progressively filled in
 
Top