Excel Sort 1

[E1Designs]

I have a list:

A
A1
B
B1
C
C1
A
B

I need it to be sorted like this:

A
A
B
B
C
A1
B1
C1

etc...

 

[AnotherHiggins]

I don't think you'll be able to do it with Excel's native functionality. But you could use a 'helper column'.

Say your data is in Column A. In column B, enter this formula:
[COLOR=blue white]=LEN(A2)&A2[/color] (assuming row 1 contains header data)

Then sort by column B.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[E1Designs]

That does not seem to be giving the correct results. ;/

 

[AnotherHiggins]

It works fine on the example data you provided.

Do you have other datatypes? Maybe you have A2 and you want that sorted after C1?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[PHV]

And maybe you forgot to copy down the formula ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wellas666]

Or try this:

Data is in Column A. In column B2, enter this formula:
=LEN(A2) (assuming row 1 contains header data) and copy down the formula.

Then sort by column B,A.

 

[AnotherHiggins]

wellas666,

I don't see how that would work any differently than my suggestion.

Are you still having trouble, E1Designs?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[E1Designs]

I got it, thanks all