use a helper column with
=if(or(Cheque0,Cash0),1,""
filter by this column and the date column.

"MrSkoot99" wrote:

I have a worksheet to track tithing at my church. The data is in rows with
name, address, phine #, etc and the amounts for each week in columns (lone
each for cheque and cash).

I want to be able to select all those donating in the last 4 months.

"bj" wrote:

What is the problem with the filter?
What is the critera?
is it all in one column?

"MrSkoot99" wrote:

I want to select rows of data from a worksheet based on one cxriteria in
multiple rows. I cannot get the filter command to produce the correct result.

Help!!