J
Josh O.
Is there a way to have autofilter filter everything according to my
conditions except for the last 5 rows of a worksheet?
conditions except for the last 5 rows of a worksheet?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Ken Wright
Can you live with a blank row between your data and the last 5 records - if
so just add a blank row - You may have to reset the filter range, but
hopefully you shouldn't.
so just add a blank row - You may have to reset the filter range, but
hopefully you shouldn't.
G
Gord Dibben
Josh
Stick a blank row above the last 5 rows then select just top row when
Data>Filter>Autofilter.
i.e. Do not select entire column.
Autofilter will ignore those rows below the blank row.
Gord Dibben Excel MVP
Stick a blank row above the last 5 rows then select just top row when
Data>Filter>Autofilter.
i.e. Do not select entire column.
Autofilter will ignore those rows below the blank row.
Gord Dibben Excel MVP
J
Josh O.
Thanks to both of you!!
Gord Dibben said:Josh
Stick a blank row above the last 5 rows then select just top row when
Data>Filter>Autofilter.
i.e. Do not select entire column.
Autofilter will ignore those rows below the blank row.
Gord Dibben Excel MVP