Hi Folks,
Sorry if I sound silly. But, is there a way to sort by the last two digits before the hyphen, without removing the numbers after the hyphen? ie. 12306-97 , 123000-17, 154312-15, 965434-18, etc. I can do this slowly by combing through the spreadsheet but it is inefficient and I end up skipping a few on the first round of review.
With the huge spreadsheet that I get from work, the numbers after the hyphen are years. But, I only work on those which end in 00 to 12 before the hyphen. So, from the example above , I only need to pay attention to 12306-97, 123000-17, and 154312-15. I hope this sort of makes sense. Please help.
Sorry if I sound silly. But, is there a way to sort by the last two digits before the hyphen, without removing the numbers after the hyphen? ie. 12306-97 , 123000-17, 154312-15, 965434-18, etc. I can do this slowly by combing through the spreadsheet but it is inefficient and I end up skipping a few on the first round of review.
With the huge spreadsheet that I get from work, the numbers after the hyphen are years. But, I only work on those which end in 00 to 12 before the hyphen. So, from the example above , I only need to pay attention to 12306-97, 123000-17, and 154312-15. I hope this sort of makes sense. Please help.
