Excel's built-in sort options are powerful and effective tools, but they do not always work correctly when it comes to sorting dates. This tutorial will teach you a few useful tricks to arrange Excel spreadsheets by date in a meaningful way without messing up your data. Continue reading
Comments page 2. Total comments: 42
Hi Alexander,
How can I auto sort multiple data fields on one spreadsheet.
For Example using example given. if you split the citrus fruit and the other fruit into to separate data fields. Hope that makes sense.
I believe that is what Matt is asking for above, post 6.
Cameron
I have been searching for hours to find a way of writing dates so that they can be sorted.
In spite of reading everything with great care nothing seems to work in the way that it should.
Even the simple things, if I write a four figure no. and irrespective of which format I use, Excel accepts that no. as either 2units + 2 decimal places or the decimalised figure rounded up to the next whole no.
For example 1785 would be shown as 17.85 or 18.
What am I not doing ?
Hello!
I’m sorry but your task is not entirely clear to me. Could you please describe it in more detail? 1785 is a number, not a date. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
It’ll help me understand it better and find a solution for you.
Is there a way to make the same code but with multiple sort layers?
Need help posting a formula that will automatically sort by date after after new entries are made.
0000-00 Smith John Doe 1/1/87 Monday, October 22, 2001 LV
I have 7 columns and I would like it sorted by date or column 6.
Can anyone advise how to accomplish this?
Hello!
If the date is inside the text in the cell, then sorting by this date is not possible. You have to extract the date into a separate column. Please have a look at this article — How to convert text to date
NOTHING TO UNDERSTAND
Sort data into student quiz and arrange marks in descending order one example
Respected Sir i want short by subject of the student for examples
Sr. No. Name Student ID Subject
1. Ram BA20201 Hindi, English, History,
2. Shyam BA20202 Sanskrit, Political Science, History
3. Mohan BSC20192 Music, Drama, History
4. Sohan BCom Hindi, English, Accounting
now i want to know how many student has taken Hindi and with hindi which subject taken by all the student those who have take hindi
Hello!
To calculate the number of students, use the formula
=COUNTIF(D2:D40,"*Hindi*")
To get a list of subjects, each of them must be recorded in a separate column. Then you can apply this instruction.
thanx,do u provide hep in all office tools?