Moving rows with multiple criteria

P

PAL

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?
 
M

Max

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
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top