Sort by last two characters, not the first.
hi
use a helper column along side of your data.
assuming the example data in in column A, in the helper column, enter this
=right(A2,2)
this will draw the last 2 characters of the data into the helper column
use the helper column as the primary sort.
regards
FSt1
"gino986" 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.
|