How do I sort a column using the last number in the cell?

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I need to sort a spreadsheet by using the last digit in a column that has
department numbers.

EX: 300009
300006
300004

Thank you!
 
hi
use a helper column.
in a column to the right of the data, enter this formula.....
=right(A2,1)
copy down.
use the helper column as the primary sort key.

regards
FSt1
 
Hi,

use a helper column to extract the last number

=RIGHT(A1,1)

Select both columns and sort on the helper column which you can hide.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
You must log in or register to reply here.

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

sort a cell by last two digits 4
How to sort entire spreadsheet by one column sort 5
Countif wrong in last row or two 3
How can I sort a list of numbers by the last 4 digits? 2
sort data automatically by the last column in the table 2
Auto-Sort Won't Sort All Column Cells 1
Sorting within Rows 7
Sorting or Filtering 5

Back
Top