How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask simitpatel Your Own Question
simitpatel
simitpatel, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 5747
Experience:  MCSE, and working with Office for over 10 years.
15190142
Type Your Microsoft Office Question Here...
simitpatel is online now
A new question is answered every 9 seconds

I cant create a custom sort

This answer was rated:

I can't create a custom sort of A+, A, A-, B+, B, B-, C+, C, C-. When I do and I click my custom sort, I get: A+, A-, B+, B-, C+, C-, A, B, C. I am using Excel 2010.  I need this for a pivot table.  I can send you a sample file, if need be.


simitpatel :

Hello.Please let me know when you are ready.

Customer:

I am online

simitpatel :

OK. Could you please copy and paste the custom sort list entries that you have setup for this CusXXXXX XXXXXst so that I can take a look at that.

Customer:

A+
A
A-
B+
B
B-
C+
C
C-
D+
D
D-
F

simitpatel :

Could you confirm that the cells that have a letter, without the '+' or '-' symbol ONLY have the letter. You will want to make sure that there isn't any space before or after the letter.

Customer:

Yes. The cells that only have a letter, only have the letter. No space before or after

simitpatel :

Could you please send me the spreadsheet so that I can take a look at it. Just go to http://wikisend.com and upload the file there. After the file is uploaded, it will give you a link to the file. Just copy and paste that link here.

Customer:

that site is giving me errors. is there another way to upload

simitpatel :

Try this one:

simitpatel :

http://host03.pipebytes.com/

Customer:

http://host03.pipebytes.com/get.php?key=103190499370867

Customer:

I think my office firewall is blocking both of these sights.

simitpatel :

OK. It seems that the cells that have just the letter do have a space after the letter which is what the problem is here. Try this: on a few of the 'A's, just delete the cell, and manually type in the letter 'A', without a space afterwards, and then run the custom sort again. The 'A's that you fixed will be sorted correctly.

Customer:

that is it.

simitpatel :

Do you know how to fix that using search and replace, or do you want me to walk you through that?

simitpatel :

If you need help with that, just let me know. Otherwise, please rate my answer with a positive rating. Any bonuses and feedback are greatly appreciated.

Customer:

I just did it and it worked.

simitpatel :

That's very good news :)

simitpatel :

Let me know if you need any more help. Please don't forget to rate my answers.

simitpatel and other Microsoft Office Specialists are ready to help you

Related Microsoft Office Questions