If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filters don't work after combining several spreadsheets into one
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! |
#3
|
|||
|
|||
filters don't work after combining several spreadsheets into o
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! . |
#4
|
|||
|
|||
filters don't work after combining several spreadsheets into o
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! . |
Thread Tools | |
Display Modes | |
|
|