Hello I have a column with dates and times of measurement, each cell is written as "7/12/2020 10:14 PM" for example. Currently the dates and times are listed from newest to oldest and I need them to be oldest to newest. I'm not sure how I'd use sort & filter in this situation considering there are numbers and text in the cells. If someone could help me out with this I'd greatly appreciate it, thank you.
My immediate thought is to produce a helper column with just the numbers (date and time) and sort/filter both columns based on that.
To get more help please utilize the banner at the top of the page to show us a small sample of the data that needs sorting.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks