Thread: How do I sort a column using the last number in the cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
  
Posts: 3,942
Default How do I sort a column using the last number in the cell?
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

"Susan" wrote:

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

EX: 300009
300006
300004

Thank you!
Reply With QuoteReply With Quote