ExcelBanter - Sorting data

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sorting data (https://www.excelbanter.com/excel-discussion-misc-queries/112573-sorting-data.html)

Maback

Sorting data

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?

Roger Govier

Sorting data

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, DataSortchoose
helper column letterAscending

--
Regards

Roger Govier

"Maback" wrote in message
...
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?

Maback

Sorting data

Thank you Roger, worked out fine!

"Roger Govier" wrote:

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, DataSortchoose
helper column letterAscending

--
Regards

Roger Govier

"Maback" wrote in message
...
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?

All times are GMT +1. The time now is 02:29 PM.