Sort by cities

[Sahak]

Hi all,

Is it possible with Excel VBA to sort data according to the text in record, in this case city, above

Whitsett Ave (N. Hollywood)
Victory Blvd (N. Hollywood)
Kenneth Rd (Burbank)
Alameda Ave (Burbank)
Kenneth Rd (Burbank)
Central Ave (Glendale)
Central Ave (Glendale)

To get:

Alameda Ave (Burbank)
Kenneth Rd (Burbank)
Kenneth Rd (Burbank)
Central Ave (Glendale)
Central Ave (Glendale)
Victory Blvd (N. Hollywood)
Whitsett Ave (N. Hollywood)

Thank you in advance

 

[Misca]

With a helper column it shouldn't be that difficult at all. All you need to do is split the column, sort both columns according to that and then delete the helper column (if you must). I can't write you a working code because with VBA you need to know the worksheet structure etc.

If you have Power Query ( originally a free add in for Excel 2010, later renamed "Get & Transform" and put to the Data tab of the ribbon) you can do the same without VBA.

 

[Joe4]

You don't even need to split the columns, just add a helper column with the following formula (for an entry in cell A2):

=MID(A2,FIND("(",A2),LEN(A2))

You can then sort by the helper column (and even hide it, if you do not want to see it).

 

[Sahak]

Thank you Joe very much.

 

[Joe4]

You are welcome.
Glad we were able to help.