Try hilighting row 3 and then selecting Data-Filter-Auto Filter

"Shookone69" wrote:


I'm trying to do a simple filter except the top row of my sheet isn't
the labels I need on the sheet ex.

A1-Title
B1-BLANK
A3-Column 1 B3-Column 2 C3- Column 3...........

I'm trying to filter by column 3 which has two different values a & b,
but when I try to autofilter the column in picks up the title as the
labels row, and the labels I'm using as an option, so when I select my
values a or b it doesn't show my column headings


--
Shookone69
------------------------------------------------------------------------
Shookone69's Profile: http://www.excelforum.com/member.php...o&userid=23799
View this thread: http://www.excelforum.com/showthread...hreadid=374549