Excel 2007 : Filter Report + Rows With Gaps?

[benoj2005]

Is it possible to do a filter which ignores rows with gaps and continues the filters?

Filtering on gaps.xlsx

See example, only filters row row 2, then because row 3 is blank, it ignores any row after row 3.

[benishiryo]

hi benoj2005. you can simply highlight the range you want to filter & then do the Autofilter. In this case, select A1:B6

[benoj2005]

hi benoj2005. you can simply highlight the range you want to filter & then do the Autofilter. In this case, select A1:B6

I feel silly!!! Thanks