Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter
I have a spreadsheet on a shared directory. A colleague has entered data
whilst it was filtered. This appears to have resulted in the data she entered to only be found whilst filtered, and not from the full list. For example, I think she filtered it on job title and then entered the name and address. I can not only find the name and address on the filter if I filter on the job title first, and can not find them on the filter if I do it from the full worksheet. I hope this makes sense to someone. If there is any way for resolving this I would be grateful. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter
I've never run into data that appears only when a list is filtered and, if
it's happening, I cannot explain it. But have you tried doing a Find on the item with the list unfiltered? -- Jim "RLB" wrote in message ... |I have a spreadsheet on a shared directory. A colleague has entered data | whilst it was filtered. This appears to have resulted in the data she | entered to only be found whilst filtered, and not from the full list. For | example, I think she filtered it on job title and then entered the name and | address. I can not only find the name and address on the filter if I filter | on the job title first, and can not find them on the filter if I do it from | the full worksheet. I hope this makes sense to someone. If there is any way | for resolving this I would be grateful. | | Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |