Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i want the excel sort the values A to Z first then take the duplicate values to sort it again below A to Z like the following:

if i have the values a,c,b,e,d,a,c when i sort it a to z it's look like this = a,a,b,c,c,d,e but i want it look like this = a,b,c,d,e,a,c

share|improve this question
up vote 3 down vote accepted

You can use a helper column for that, no macro required.

If your data is in column A and row 1 is used for labels, put this formula in cell B2 and copy down

=COUNTIF($A$1:A2,A2)

Note the placement of the $ signs. Enter a column header in B1, for example "Count". Then click the Data ribbon > Sort. Create a sort by "Count" and add a second sort level to sort by "Data" (or whatever the label for column A is.)

enter image description here

share|improve this answer
    
thank you so much it's work. – Monther Jan 31 '13 at 9:08

It appears to be a non-standard functionality that you might have to implement yourself using VBA macros. However, this would require you to know how to program.

share|improve this answer
    
thank you for your attention. – Monther Jan 31 '13 at 9:17

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .