Sort by last digit of cell

  • Thread starter Thread starter dreambastion
  • Start date Start date
D

dreambastion

I have a single column of values, invoice numbers. I would like to sor
the column by the last digit of the invoice number. Is this possible
and if so, how
 
Hi
one way: use a helper column with the formula
=RIGHT(A1,1)
and sort with this column
 
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

Continuous Invoice Nos. 3
How to Populate Data from a table to another 0
Data Validation to exclude blank cells 6
sum column D based on column A 1
VBAscript for data matching excels 0
Find Duplicates 9
sort a cell by last two digits 4
How do I sort a column using the last number in the cell? 2

Back
Top