Sort numbers by the first integer
 

I have a column of numbers that I sort based on the first integer. For
example,
I want
2
4
77
555
777
11111

to sort as

11111
2
4
555
77
777

Is there a way to do that? Thanks.


--
skiman123321
------------------------------------------------------------------------
skiman123321's Profile: http://www.excelforum.com/member.php...o&userid=36890
View this thread: http://www.excelforum.com/showthread...hreadid=566074

Sort numbers by the first integer
 

skiman123321 wrote:

I have a column of numbers that I sort based on the first integer. For
example,
I want
2
4
77
555
777
11111

to sort as

11111
2
4
555
77
777

Is there a way to do that? Thanks.


Hi skiman123321

Use a helper column with =LEFT(A1,1) copied down as far as necessary.

Then sort the two columns based on the helper column.

Regards

Steve

Sort numbers by the first integer
 

Try using a helper column that has just the first digit: =left(a2,1), and
sort on that column. You can always delete or hide the column after sorting.

--
Sincerely, Michael Colvin


"skiman123321" wrote:


I have a column of numbers that I sort based on the first integer. For
example,
I want
2
4
77
555
777
11111

to sort as

11111
2
4
555
77
777

Is there a way to do that? Thanks.


--
skiman123321
------------------------------------------------------------------------
skiman123321's Profile: http://www.excelforum.com/member.php...o&userid=36890
View this thread: http://www.excelforum.com/showthread...hreadid=566074

Sort numbers by the first integer
 

Thank you very much.


--
skiman123321
------------------------------------------------------------------------
skiman123321's Profile: http://www.excelforum.com/member.php...o&userid=36890
View this thread: http://www.excelforum.com/showthread...hreadid=566074

Sort numbers by the first integer
 

Your very welcome. Thanks for the feed back.
--
Sincerely, Michael Colvin


"skiman123321" wrote:


Thank you very much.


--
skiman123321
------------------------------------------------------------------------
skiman123321's Profile: http://www.excelforum.com/member.php...o&userid=36890
View this thread: http://www.excelforum.com/showthread...hreadid=566074

Sort numbers by the first integer
 

format the cells as text and then sort

"skiman123321" wrote:


I have a column of numbers that I sort based on the first integer. For
example,
I want
2
4
77
555
777
11111

to sort as

11111
2
4
555
77
777

Is there a way to do that? Thanks.


--
skiman123321
------------------------------------------------------------------------
skiman123321's Profile: http://www.excelforum.com/member.php...o&userid=36890
View this thread: http://www.excelforum.com/showthread...hreadid=566074