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

Connie Martin

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 ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Connie Martin" wrote in message
...
How do you sort a list of hyphenated and non-hyphenated numbers so that
2079-1 comes before 2121?

Connie Martin

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

"Max" wrote:

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 ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Connie Martin" wrote in message
...
How do you sort a list of hyphenated and non-hyphenated numbers so that
2079-1 comes before 2121?

Connie Martin

You're welcome !
Thanks for posting back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Connie Martin" wrote in message
...
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

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

--
Many thanks

Lise


"Max" wrote:

You're welcome !
Thanks for posting back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Connie Martin" wrote in message
...
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

Pl start a new thread. This thread is long closed.
Try posting in .programming if your query is on macros.
Good luck
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---