I need to rearrange the information in a column. Help?

  • Thread starter Thread starter lbrown
  • Start date Start date
L

lbrown

I need to sort the data in the column by the last few digits in the column
and not the first few. Is this possible?
 
You could insert a helper column to parse off the digits you want and then
sort on the helper column.

Insert a new column to the left of the data
Let's say you want the last 3 digits. Use RIGHT(A1,3) and copy the formula
down the column.

Now you can do your sort on the helper column.
 
Say you want to sort by the last 4 digits of data in column A. In B1, enter:

=RIGHT(A1,4) and copy down

Then sort cols A & B by B
 
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

Rearranging and renumbering data in rows 3
Help needed 0
Reoreder/Rearrange columns through Macros 5
how do I sort data excluidng headings? 2
sorting columns sorts header values too 6
Sorting multiple columns (fields) in a pivot table 1
How do I sort a column using the last number in the cell? 2
Multi-column sort issue in Pivot Table 3

Back
Top