I filtered on the entire selection (not just the top row), got rid of row 2,
custom filtered on begins with n
If you want a macro to do this for you I can set it up on an xlsM file with
a button for N and a button for N

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Trina" wrote in message
...
Thanks - I just sent the sheet.

"Don Guillett" wrote:


If desired, send your file to my address below. I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Trina" wrote in message
...
Hi! I could use some help with filters.

I have a spreadsheet I distributed to others to complete and return to
me.
Once I got the copies back I combined them into one by copy and pasting
the
data into one spreadsheet.

Now, though, when I try to sort a column to exclude all "N"s not all
"N"s
are excluded. (data is a variety of yes, y, no, N, yes-dept #'s...)

I've tried removing the filters, and re-filtering, but it doesn't work.

I've tried selecting a cell ("N") that is not excluded but should be,
then
filtering on that, but that process misses other information.

Any ideas?

Thanks!

.