Sort A to Z
When I clear the Filtter that data will not go back as in the order that I
write it. |
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. |
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. |
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. |
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. |
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. |
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