The Shrine

<div style='font: 9pt ; text-align: left; '>I have a sheet with information on stores, one of the columns contains a number which ends with a number 5 or a 7. For example 101005 or 102007 and so on.

I need to find a way to sort the list by 5 or 7.

I have tried autofill options which doesnt work.

Please let me know if you have any ideas on how to do this.

-------------------------------
column1 column2 column3
101 ab 101005
102 cd 102007
103 ef 103005
etc etc etc

I need to sort by last digit of column 3.

Creating new columns and entering new numbers is NOT what I am asking for. There is a way to do it quickly Iv seen it done but its driving me crazy.</div>

<div style='font: 10pt "EngraversGothic BT", "Copperplate Gothic Light", "Century Gothic"; text-align: left; '>Data/Text to Columns is your friend. You could also use modulo math (nothing but the reminder), with something like =MOD(E3, 10). In any case, you NEED another field, even if it's a hidden one (with zero-width on the column).</div>

<div style='font: 12pt "Cooper Black"; text-align: left; '>I first thought =MOD, too. Its sloppy and you need to make another coulmn (which you can hide later), but here is what i would use: =IF(MOD(A1,5)=0,"1","2") with this the **5's would get a 1 and the **7 would get a 2. Sort that column, hide it, then move on.</div>

<div style='font: 10pt "EngraversGothic BT", "Copperplate Gothic Light", "Century Gothic"; text-align: left; '>But, the number could potentially be 0-9, so if you're going to hide the column anyway, why turn a sorted number into a sorted IF condition?</div>

<div style='font: 12pt "Cooper Black"; text-align: left; '>i didnt think there would be any other last digit possibilities besdies 5 and 7. I suppose i did over complicate it, i just using IF's ^_^</div>

<div style='font: 12pt "Cooper Black"; text-align: left; '>i didnt think there would be any other last digit possibilities besdies 5 and 7.  I suppose i did over complicate it, i just like using IF's  ^_^</div>