Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort A to Z
When I clear the Filtter that data will not go back as in the order that I
write it. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
how can I hide sort ascending and sort descending options in the . | Excel Discussion (Misc queries) |