Sorting numbers before hyphen and within range

SuperJam

New Member
Joined
Feb 19, 2018
Messages
2
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.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
You could add a column with this formula
=MID(A1,FIND("-",A1)-2,2)
which extracts the 2 numbers before the hyphen, then sort by that column. Change A1 to suit.
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top