Hi, I'm having difficulties sorting this data. I want to sort the data by column Z, yet every time I click to sort the data it won't reorder. I am also worried that when I click to sort the data it will only sort that row and not keep the information specific to each row. Any help would be appreciated, thanks
Hello gonzo5000 and welcome to the forum
Take a look at this link to get you started
http://contextures.com/xlSort01.html
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
I tried that and the data still wont sort. Does the fact the the column is made up of equations have anything to do with the fact that its not sorting.
Hello there,
Is it possible you could provide a zipped sample of your spreadsheet (if its not sensitive data) and I’ll have a look to see if I can spot what the problem is?
To post a zipped example, go to “My Documents” or wherever you have your file stored, right-click and “Send to > Compressed file”, then attach this zipped file to your post.
Here is the file, hope you can tell me whats wrong, thanks again for the help
Try this, select A4:AA249 then go to Data > Sort and sort by column Z, this will sort all rows but keep the data in the relevent row
When you do that does every row get sorted. For me often some rows are not sorted while the majority of them end up being sorted the way I want. Just wondering why some cells are sorted and others arent.
Yes every row gets sorted, may be you have the same data in some cell, so you "think" those cells haven't been sorted, but really they have.Originally Posted by gonzo5000
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks