ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort A to Z (https://www.excelbanter.com/excel-discussion-misc-queries/231520-sort-z.html)

Misho

Sort A to Z
 
When I clear the Filtter that data will not go back as in the order that I
write it.

Eduardo

Sort A to Z
 
Hi,
You have another post where you said you sort the column, so once you clear
the filter it will keep the information as you sorted not in the original
format, look how do you get the information, by date?, or by code #? etc. and
sort it again

If this was helpful please click yes, thanks

"Misho" wrote:

When I clear the Filtter that data will not go back as in the order that I
write it.


Misho

Sort A to Z
 
Thanks Eduardo,

but When I fill the data I was entering it, the referance was the number of
the execl befoer A column, how can return items to their original order
before sortting.

to click Yes,

Awaiting your feedback.



"Eduardo" wrote:

Hi,
You have another post where you said you sort the column, so once you clear
the filter it will keep the information as you sorted not in the original
format, look how do you get the information, by date?, or by code #? etc. and
sort it again

If this was helpful please click yes, thanks

"Misho" wrote:

When I clear the Filtter that data will not go back as in the order that I
write it.


Eduardo

Sort A to Z
 
Hi Misho,
please provide an example, I don't understand what you mean with the number
of excel before column A. thanks

"Misho" wrote:

Thanks Eduardo,

but When I fill the data I was entering it, the referance was the number of
the execl befoer A column, how can return items to their original order
before sortting.

to click Yes,

Awaiting your feedback.



"Eduardo" wrote:

Hi,
You have another post where you said you sort the column, so once you clear
the filter it will keep the information as you sorted not in the original
format, look how do you get the information, by date?, or by code #? etc. and
sort it again

If this was helpful please click yes, thanks

"Misho" wrote:

When I clear the Filtter that data will not go back as in the order that I
write it.


Misho

Sort A to Z
 
There is no referance to my data or special criteria, but when I clear the
sort A to Z, the return items to their original order before sortting.

Misho.

"Eduardo" wrote:

Hi Misho,
please provide an example, I don't understand what you mean with the number
of excel before column A. thanks

"Misho" wrote:

Thanks Eduardo,

but When I fill the data I was entering it, the referance was the number of
the execl befoer A column, how can return items to their original order
before sortting.

to click Yes,

Awaiting your feedback.



"Eduardo" wrote:

Hi,
You have another post where you said you sort the column, so once you clear
the filter it will keep the information as you sorted not in the original
format, look how do you get the information, by date?, or by code #? etc. and
sort it again

If this was helpful please click yes, thanks

"Misho" wrote:

When I clear the Filtter that data will not go back as in the order that I
write it.


Eduardo

Sort A to Z
 
Hi Misho,
Once you sort the items if you saved the spreadsheet you will not be able to
recover the original order, if you need to perform some calculations is
better to create a copy in a different tab and always have the original data
as it, unless the data come sorted by date so you can come back and sort it
by date after sorting it be name

"Misho" wrote:

There is no referance to my data or special criteria, but when I clear the
sort A to Z, the return items to their original order before sortting.

Misho.

"Eduardo" wrote:

Hi Misho,
please provide an example, I don't understand what you mean with the number
of excel before column A. thanks

"Misho" wrote:

Thanks Eduardo,

but When I fill the data I was entering it, the referance was the number of
the execl befoer A column, how can return items to their original order
before sortting.

to click Yes,

Awaiting your feedback.



"Eduardo" wrote:

Hi,
You have another post where you said you sort the column, so once you clear
the filter it will keep the information as you sorted not in the original
format, look how do you get the information, by date?, or by code #? etc. and
sort it again

If this was helpful please click yes, thanks

"Misho" wrote:

When I clear the Filtter that data will not go back as in the order that I
write it.


Misho

Sort A to Z
 
Thanks Eduardo, it seems there is no solution of my question, but I will keep
looking.

I have clicked Yes.


"Eduardo" wrote:

Hi Misho,
Once you sort the items if you saved the spreadsheet you will not be able to
recover the original order, if you need to perform some calculations is
better to create a copy in a different tab and always have the original data
as it, unless the data come sorted by date so you can come back and sort it
by date after sorting it be name

"Misho" wrote:

There is no referance to my data or special criteria, but when I clear the
sort A to Z, the return items to their original order before sortting.

Misho.

"Eduardo" wrote:

Hi Misho,
please provide an example, I don't understand what you mean with the number
of excel before column A. thanks

"Misho" wrote:

Thanks Eduardo,

but When I fill the data I was entering it, the referance was the number of
the execl befoer A column, how can return items to their original order
before sortting.

to click Yes,

Awaiting your feedback.



"Eduardo" wrote:

Hi,
You have another post where you said you sort the column, so once you clear
the filter it will keep the information as you sorted not in the original
format, look how do you get the information, by date?, or by code #? etc. and
sort it again

If this was helpful please click yes, thanks

"Misho" wrote:

When I clear the Filtter that data will not go back as in the order that I
write it.



All times are GMT +1. The time now is 10:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com