filters don't work after combining several spreadsheets into one

[Trina]

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!

 

[Don Guillett]

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.

 

[Trina]

Thanks - I just sent the sheet.

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
(e-mail address removed)


.

 

[Don Guillett]

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