Sorting hyphenated numbers

G

Guest

How do you sort a list of hyphenated and non-hyphenated numbers so that
2079-1 comes before 2121?

Connie Martin
 
M

Max

Try sorting the list on an adjacent helper col

Assuming the list is in col A, A1 down

Put in B1: =TEXT(A1,"@")
Copy down

Then sort both cols A and B by col B > Ascending

This should return the results ..
 
G

Guest

Thank you. That works. I put the column outside the print area. I was
hoping there would be a list one could create and then sort by it, but I
guess not.

Thanks again
Connie Martin
 
L

Lise

Hi Max

Have been reading your replies to the question from Connie which has been
great so far - but I have hit a brick wall. I am using hyphenated and unique
numbering which I have sorted into the order I want (see below), used your
additional column and added =TEXT(C2,"@").
What I want to do now is create a macro so that on the press of a button I
can have the whole sheet auto sort (which with usual numbering works really
well) ie new entry entered hit CTRL o and everything auto sorts. But in this
case data already in teh sheet stays in the order I manually entered BUT new
new entries remain at the bottom and don't update - do you know what I'm
missing please?
07074
07075
07076
07076-01
07076-02
07C08-001
07C08-002
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom List 12
decimal sorting 3
Virus that deletes hyphenated numbers (phone numbers)? 4
sorting hyphenated numbers 3
How do I search for hyphenated words in Outlook 2007? 1
Comparing dientical part numbers but with different prices 3
sorting hyphenated numbers 8
Where is the command for "widows and orphans"? 1

Top