data sort

  • Thread starter Thread starter a_nona_mouse
  • Start date Start date
A

a_nona_mouse

ok now should be simple >>

I need to sort by month on data that is held in format >> day/month

so eg
1511
1510
3011
3010

now
custom/ends with/ 11... does not work
custom/ends with/ ??11.. or *11 does not work either
contains 11 does not work (& would also be wrong if data set contained 1011)
but still I am stumped so any help would be great

cheers

Alex
 
I would be inclined to add a new, temporary field of formulas that pull off
the right 2 digits, and sort by that: =RIGHT(A1,2)
 
Back
Top