Sorting data by last to digits

  • Thread starter Thread starter Brian
  • Start date Start date
B

Brian

I have a worksheet that I need to sort by terminal digits (last 2 digits).

The data is in column A in the format:

'0004135296

Notice the ' at the beginning.

I need to sort this data by the 96 at the end.

Thanks.
 
I have a worksheet that I need to sort by terminal digits (last 2 digits).

The data is in column A in the format:

'0004135296

Notice the ' at the beginning.

I need to sort this data by the 96 at the end.

Thanks.
Click to expand...

Since your data is in text format, start a new column to the right of
your data and enter =RIGHT(A1,2) with A1 being your first entry in
your table. Copy it to the bottom row of your table and sort on the
new column.

Don S
 
Thanks a million!



Don S said:
Since your data is in text format, start a new column to the right of
your data and enter =RIGHT(A1,2) with A1 being your first entry in
your table. Copy it to the bottom row of your table and sort on the
new column.

Don S
Click to expand...
 

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

Sorting by last digits in cell 4
Sort Question 1
Sorting by last digit 5
Sorting a six digit number by terminal digit 10
Sort by last 2 digits 4
Sorting from last Digit 0
how can i sort on a perticular column for odd and even numbers 3
Sort on last two digits of data 3

Back
Top