| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
filter
I have made a filter in huge data based ( sort A to Z ) tow weeks before, but
when I clear the filter, but the data didn't comeback as it was as before in the original order. how can I get it solved? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
Filter will not rearrange data. Was the data sorted while it was filtered?
"Misho" wrote: I have made a filter in huge data based ( sort A to Z ) tow weeks before, but when I clear the filter, but the data didn't comeback as it was as before in the original order. how can I get it solved? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
If you saved the workbook with the data sorted your only recourse is to dig
out the backup copy. If you did not save, close without saving. Gord Dibben MS Excel MVP On Thu, 21 May 2009 02:34:01 -0700, Misho wrote: I have made a filter in huge data based ( sort A to Z ) tow weeks before, but when I clear the filter, but the data didn't comeback as it was as before in the original order. how can I get it solved? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
Hi Sean Timmons,
Thanks for your response, I'm note sure, as my brother was working on it last week and save it. and when I clear the sort and the filter, it doesn't returned to the order, as there wasn't a reference to my data, as I was Depending on the Excel reference "Sean Timmons" wrote: Filter will not rearrange data. Was the data sorted while it was filtered? "Misho" wrote: I have made a filter in huge data based ( sort A to Z ) tow weeks before, but when I clear the filter, but the data didn't comeback as it was as before in the original order. how can I get it solved? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
filter
If data was sorted while filtered, it doesn't always sort the entire table.
Best thing you can do now is sort the data with the filter set to show all or removed... "Misho" wrote: Hi Sean Timmons, Thanks for your response, I'm note sure, as my brother was working on it last week and save it. and when I clear the sort and the filter, it doesn't returned to the order, as there wasn't a reference to my data, as I was Depending on the Excel reference "Sean Timmons" wrote: Filter will not rearrange data. Was the data sorted while it was filtered? "Misho" wrote: I have made a filter in huge data based ( sort A to Z ) tow weeks before, but when I clear the filter, but the data didn't comeback as it was as before in the original order. how can I get it solved? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
