Sort Function

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi,
I am having trouble sorting my data, and the wizard seems
unable to help.
I have downloaded my data from another program into my
excel worksheet. The data consists of company names and
associated figures. Each company name has a number of
letters after it in the cell, (eg: Top Flight FR, Top
Flight BG, Top Flight LO, etc). I want to be able to sort
the data by the postfixed letters (FR, BG, LO, etc). I
know I could insert another column and separate out the
name and then sort, but there is a lot of data and I need
to do this regularly.
So basically is it possible to sort, or set up a custom
sort to do it by cells containing certain letters?

ps: I cannot really change the data much before I download
it to excel.

Hope you can all help.

Alex
 
Hi Alex
if you want to use Excel sorting functionality you have to use a helper
column (AFAIK). But you can easily use one formula for this helper
column. e.g.
=RIGHT(A1,2)
in your case. insert this in the first row of your data and double
click on the lower right corner of this cell selection. This should
fill this formula down for all rows
 
Thanks, that works well.

Alex
-----Original Message-----
Hi Alex
if you want to use Excel sorting functionality you have to use a helper
column (AFAIK). But you can easily use one formula for this helper
column. e.g.
=RIGHT(A1,2)
in your case. insert this in the first row of your data and double
click on the lower right corner of this cell selection. This should
fill this formula down for all rows

--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Back
Top