Sorting data

G

Guest

I have over 1000 10 digit number productcodes listed in one column, and I
would need to sort them by the by the last three digits. Any suggestions?
 
R

Roger Govier

Hi

Assuming your data is in column A, create a helper column with the
formula
=RIGHT(A1,3)
Copy down as far as required.
Mark all of the data including the new helper column, Data>Sort>choose
helper column letter>Ascending
 
G

Guest

Thank you Roger, worked out fine!

Roger Govier said:
Hi

Assuming your data is in column A, create a helper column with the
formula
=RIGHT(A1,3)
Copy down as far as required.
Mark all of the data including the new helper column, Data>Sort>choose
helper column letter>Ascending
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 or Filtering 5
How do I sort a column using the last number in the cell? 2
Excel Sorting 4
How can I sort a list of numbers by the last 4 digits? 2
How do I sort by the first digit of a number? 7
Aplpha Numeric Mixed Sorting 6
sorting a series of nos. on basis of digits 1
merging two sets of data 2

Top