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

 

[Shoaib]

Insert a three rows above your data.
Give your column a heading and then copy and paste the heading into A1
in A2 type the criteria >1
Now click in your database,
Ensure that the advanced filter has your data range and then select A1:A2 for your criteria, choose a location on the same sheet
this should work!