Advance_Filtering

[rlnye]

I am trying to use Advanced filtering to move rows with a number >1 to another area of the worksheet. But, when I run the filter it moves even the blank rows. This is an example:

A B C
1 2 Apples Large
2 Peaches Small
3 4 Pears Large
4 Bananas Large
5 2 Oranges Large
The formula I'm using is =A1>1(A1:C5)
and moving results to F10

 

[eliW]

On 2002-08-23 05:49, rlnye wrote:
I am trying to use Advanced filtering to move rows with a number >1 to another area of the worksheet. But, when I run the filter it moves even the blank rows. This is an example:

A B C
1 2 Apples Large
2 Peaches Small
3 4 Pears Large
4 Bananas Large
5 2 Oranges Large
The formula I'm using is =A1>1(A1:C5)
and moving results to F10

Hi rlnye,

It must work.
Maybe you didn't enter correctly the Criteria; It has to be 2 cells: the upper cell empty and under it the cell with the formula: =A2>1 (D1:D2 for example).
Good luck and let me know,
Eli

 

[rlnye]

Thanks Eli, you were right, I did not have the Criteria entered correctly.

Thanks again for the help.