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