Sorting Data

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I have a long number in a column ex. 456789009876 and I would like to
sort the column by the last two numbers in this series of numbers how
can I do that ex. sort only the 76 part.

Thanks

Jason
 
Jason,

Next to your numbers ( suppose these are in column A1:A100) make a
helpercolumn (thus in column B1:B100)
In cell B1 =Value(Right(A1;2)). Copy down to B100

Now sort on column B ( and delete or hide column B)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Just to make sure (I keep forgetting to replace it) : You might need to
change the semicolon (;) between A1 and 2 in the Right function to a comma.
(I'm working with a Dutch setting ==> ; as argumentseperator)

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Back
Top