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?