Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving rows with multiple criteria
I have a spreadsheet with many rows and columns (rows will grow over time).
I am interested in filtering one column with multiple criteria (i.e. 50 different values may be possible). Is this possible? If so, how. Two problems I face is: How do I create the formula w/ multiple values? Is there a limit. I am also struggling with the concept of dynamic ranges because the number of rows will increase. Once I filter this how can I copy this to another sheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving rows with multiple criteria
I am interested in filtering one column with multiple criteria
(i.e. 50 different values may be possible). Assuming the 50 diff values are entered into say, F1:F50 Assume the col to be checked is col C, data in C2 down In D2, copied down: =IF(C2="","",COUNTIF($F$1:$F$50,C2)) Apply autofilter on col D, choose: 1 from the droplist to get the filtered results. Copy n paste elsewhere as desired. -- Max Singapore http://savefile.com/projects/236895 Downloads: 15,500, Files: 352, Subscribers: 53 xdemechanik --- "PAL" wrote: I have a spreadsheet with many rows and columns (rows will grow over time). I am interested in filtering one column with multiple criteria (i.e. 50 different values may be possible). Is this possible? If so, how. Two problems I face is: How do I create the formula w/ multiple values? Is there a limit. I am also struggling with the concept of dynamic ranges because the number of rows will increase. Once I filter this how can I copy this to another sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
Moving data from multiple rows into a single row | Excel Discussion (Misc queries) | |||
How to retrieve multiple values in multiple rows with one criteria | Excel Discussion (Misc queries) | |||
Moving Multiple Rows at one time | Excel Discussion (Misc queries) |