Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simultaneous Filtering
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simultaneous Filtering
"Mike" wrote:
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 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) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simultaneous Filtering
"Mike" wrote:
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 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,Shee t1!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(S MALL(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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simultaneous Filtering
Pl scratch earlier post, see re-take response in the other branch ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advance filtering with multiple conditons | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
Row filtering based on input box entry (column heading) | Excel Worksheet Functions | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
avanced filtering for latest date | Excel Discussion (Misc queries) |