Problems Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort the following: "03-224/WC" and "98-357/PI". As the 03 and
the 98 are YY date format. I get everything to sort like I want except for
the 98 is coming after the 03. Which I need to set the 98 to list prior to
the 03. Please advise if there is a way to change this.
Thank you for your time
 
Hi
use a helper column with the following formula:
=IF(--(LEFT(A1,2)>40,--("19" & LEFT(A1,2)),--("20" & LEFT(A1,2))
and sort with this helper column
 
Back
Top