Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AUTO FILTER
Hi All,
I have sheet with over 1,000 lines of data. Column A contains the number 1 for more than 10 lines, the number 2 for more than10 lines, The number 3 for more than 10 lines, etc., etc. , etc. Question: How can I auto filter column A for three or more numbers at the same time. Thanks very much for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
AUTO FILTER
You can use the Custom filter option and then Less than (say) 10 AND
Greater than (say) 5 to get numbers within a range, but if you are likely to want 3 disparate numbers then you could use a formula like this in a helper column, copied down: =IF(OR(A2=X$1,A2=X$2,A2=X$3),"yes","No") Put the 3 numbers you want in X1, X2 and X3, and this formula will return yes if any of them are in column A. Extend your autofilter range to include this column, and filter this column for "yes". Hope this helps. Pete On Dec 19, 7:11 pm, lehigh46 wrote: Hi All, I have sheet with over 1,000 lines of data. Column A contains the number 1 for more than 10 lines, the number 2 for more than10 lines, The number 3 for more than 10 lines, etc., etc. , etc. Question: How can I auto filter column A for three or more numbers at the same time. Thanks very much for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I auto refresh a column that has an auto filter in place | Excel Discussion (Misc queries) | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Auto Number the Rows of Auto Filter Result | Excel Discussion (Misc queries) | |||
in data/filter/auto filter | Excel Worksheet Functions | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) |