Thread: How can I sort a column by the last positions of each cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How can I sort a column by the last positions of each cell
Use another column filled with formulas like:

=right(a1,4)

Then sort by that column.

I'm not sure what kind of list you need.

SHJOHN wrote:

I need to sort a column of cells that contain 11 numeric characters each by
the last 4 positions in each cell and produce a list. There will be multiple
matches for each cell.

--

Dave Peterson
Reply With QuoteReply With Quote