Jul 20 2021 03:27 PM
Hello all
I am getting frustrated. I am trying to sort rows of contiguous data Columns A through M by the cell data in column H. I highlight all the rows and columns. I get a dialog box. It asks me what column I want to sort on. I say column H. It asks what I want to sort on. I say cell value. It asks whether I want ascending or descending. I say descending. Then I click the OK button. Nothing happens. No sort.
I have used the sort function in excel before. I have never had this kind of problem.
Thank you.
Jul 21 2021 12:45 AM
It would help if you attached a sample workbook without sensitive data that demonstrates the problem.
Jul 21 2021 06:57 AM
This data base is immense. It consists of a summary of results of standardized testing on various topics in various grades of every public school school in Pennsylvania, In fact, it may be the very size of the data base that may be a problem: it has over 48,000 rows, and the number of columns is 13.
To bring it down to manageable size, I am trying to break it up into data bases by grade and topic. In what I shown below, I have included just a few rows. I have already tried to eliminate everything not associated with the 4th grade, (grade is indicated in column H). That explains why everything in H should be 0 or 4. My idea then is to sort on H in descending order, and copy only those rows with a 4 to a data base on 4th grade. Then I will repeat that process for the various topics. I will end up with workable data bases, one per grade and topic, that I can actually scroll through to make sure everything is working correctly
112011103 | 000007302 | Adams | BERMUDIAN SPRINGS SD | BERMUDIAN SPRINGS EL SCH | English Language Arts | All Students | 0 | 0 | 0 | 0 | 0 | 0 |
112011103 | 000007302 | Adams | BERMUDIAN SPRINGS SD | BERMUDIAN SPRINGS EL SCH | English Language Arts | All Students | 4 | 123 | 24.4 | 37.4 | 27.6 | 10.6 |
112011103 | 000007302 | Adams | BERMUDIAN SPRINGS SD | BERMUDIAN SPRINGS EL SCH | English Language Arts | All Students | 0 | 0 | 0 | 0 | 0 | 0 |
112011103 | 000007302 | Adams | BERMUDIAN SPRINGS SD | BERMUDIAN SPRINGS EL SCH | English Language Arts | Historically Underperforming | 0 | 0 | 0 | 0 | 0 | 0 |
112011103 | 000007302 | Adams | BERMUDIAN SPRINGS SD | BERMUDIAN SPRINGS EL SCH | English Language Arts | Historically Underperforming | 4 | 68 | 16.2 | 30.9 | 36.8 | 16.2 |
Jul 21 2021 07:46 AM
Jul 21 2021 02:51 PM
Excel could sorts all available rows (1048576). Another story that could take time, depend on which version of Excel you are and on which hardware. Version is more critical.
Jul 22 2021 09:22 AM
Jul 22 2021 09:45 AM
Jul 25 2021 10:40 AM