Hello. My name is ***** ***** I can help you solve your problem. Thank you for your question. My goal is to provide excellent customer service.
I know that
Notwithstanding Apple's superior reputation for elegant software integration with their operating systems, it is not uncommon for some widely used applications that were originally developed for windows to be superior to versions that were later adapted for mac. The product evolution cycles are not in 100% correlation with each other, since they have been developed and maintained separately.
I would appreciate you trying the same exercise so I can determine if I have a faulty download or if the machine is just not capable of performing this pretty simple task. Thank you.
That is a good idea. I have done that. It works if you select Sort from the Data Ribbon,or if you do it by right clicking on the selected range of cells and selecting Custom Sort. I have Microsoft Office 360, which is a subscription service that includes cloud storage on the OneDrive, formerly called the SkyDrive, and my operating system is Windows 8.1.
Hi Joel - thanks for that but it works fine on the pc laptop, it's the Mac that doesn't seem to accept that third command. Can't cope with it on our machine so do you have a Mac you could try it on. That's another negative for a Mac for me - no right click! Thanks. Julie
Are you speaking of the Copy Level in the Data -Sort menu, where you can select the primary sort colum, then the secondary, followed by the tertiary, etc.? I have gone down to 5 levels, and this is only limited by the number of columns in the selected range. But keep in mind, that unless there are identical values in the intermediate columns, the lower levels will not have an opportunity to affect the sort order.
Unfortunately, I do not have access to a mac at the moment, but have I understood your question and replicated it on my pc correctly?
I am not sure if I understood what you meant by the third command, since all the sort levels are set up in one dialog box before the Sort command is executed by selecting the OK button.
Thanks for that Joel. Thought it might help to attach a page as an example.
I've been working hard to find another Professional to assist you with your question, but sometimes finding the right Professional can take a little longer than expected.
I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.
Don't mind waiting. Just need someone with a Mac to try it out on really then I'll know straight away where the problem lies!
Thanks for your help.
I got the files that you sent, and the example is just as I understood it to be. I cannot see the colors, but I get the idea. You sent me the image of an unsorted file. Not only is it unsorted in column J, but it is also unsorted in column E. (The last seven rows should be at the top with the first six rows, since these all have an 8 in column E.)
I do not have easy access to a mac, but I could do a remote desktop support session with you on your mac, so that I can see what you mean when you talk about separate operations. As I said before, it is all done in one operation by setting up the sort on the three columns as three line items within a single dialog box.
Are you saying that you cannot set up any more than two lines of sorting criteria in your sort dialog box? Please let me know if you want to do a remote desktop support session. (By the way, I did not get your name.)
Thanks for that Joel. The colour in column O goes down to where the 8s in column E start again so we know those two columns are being sorted OK, it's the third command to sort column J that the Mac just won't action. Seems to allow you to add as many lines of sorting as you like but then wont do what its supposed too! As mentioned before we're extremely familiar with working this programme on the pc so simply trying to find out if its our new excel for mac programme that's the problem and can't do that unless you have a mac to try it out on a different version of excel. Thanks. Julie
Thanks for your reply but we took our Mac over to a friends this evening and copied the programme across to his machine and it worked fine so obviously a problem with the Excel download we have on ours! Will contact the supplier and ask for a new one - fingers crossed. Thanks for trying to help anyway... Julie