Hello,

I'm having trouble with the filtering process in Excel (2007). I've got a spreadsheet with a variety of data in most of the cells in the range A1:BK2380. However, I only want to filter rows 65-1400 based on criteria in column I.

As shown in the following screenshot (Fig. 1), column I has a heading in row 1 and rows 2-4 are the necessary three rows for filtering criteria mentioned in Excel Help. Also, I've entered the filtering criteria ="=Met *" in cell I1.

In the Advanced Filter I entered the information shown in Fig. 2.

However, when I click OK, nothing happens. I know there are multiple entries in the list range which satisfy the filter criteria so I am obviously doing something wrong.

Any help would be much appreciated.

Thanks

does your list actually start in row 65 or above that row?

In the List range box you need to enter the full list reference. If you only want to filter a subset of rows, you could add a column to the table that has the row number (using =Row()), and then add criteria for that column, i.e. =">=66" and ="<=1440"

cheers, teylyn