Sort numbers by the first integer

  • Thread starter Thread starter skiman123321
  • Start date Start date
S

skiman123321

I have a column of numbers that I sort based on the first integer. Fo
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 said:
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.
Click to expand...

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
 
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.
 

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

MATCH A NUMBER IN A COLUMN WITH A COLUMN IN A DIFFERENT SHEET 1
Counting occurances and multiplying by a quantity 1
Excel Concatenate with line breaks but ignore blank cells 3
Grouping 2
Find specific info using search string using VBA 10
filtering 4
Highlight same part numbers with high price varies among themselv 3
Find specific info within a text string using VBA 4

Back
Top