View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
NBVC[_75_] NBVC[_75_] is offline
external usenet poster
 
Posts: 1
Default Sort by last two characters, not the first.


gino986;405318 Wrote:
I have a simple database; multiple rows and columns. I need to sort all
the
data by info in one of the columns. I need to sort by the LAST TWO
characters
of records in that column. Example of records:

R-BOILER-DA
R-FANCOILUNIT-QT
U-TRANSPAD-AN

All the data in the rows needs to stay together.


Create a helper column that extract those last 2 letters with formula
=Right(A2,2) where A2 has first item to sort..

Then sort the data based on this new column.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=113003