filter

[Misho]

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?

 

[Sean Timmons]

Filter will not rearrange data. Was the data sorted while it was filtered?

 

[Sean Timmons]

Filter will not rearrange data. Was the data sorted while it was filtered?

 

[Gord Dibben]

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

 

[Gord Dibben]

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

 

[Misho]

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

 

[Misho]

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]

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...

 

[Sean Timmons]

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...