Sorting data

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
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...
 
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

Sorting or Filtering 5
How do I sort a column using the last number in the cell? 2
How can I sort a list of numbers by the last 4 digits? 2
Excel Sorting 4
How do I sort by the first digit of a number? 7
Aplpha Numeric Mixed Sorting 6
merging two sets of data 2
I need to rearrange the information in a column. Help? 2

Back
Top