Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting information within a cell.
I have 3 colums of information. One of the colums contains SSN's. I need to
sort by the last 2 digits of the SSN and I can't seem to fiqure out how to do this. Any help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting information within a cell.
Assume SSN is in column D. Put this formula in a helper column:
=RIGHT(D2,2)*1 and copy down. Then include this helper column in your sort area and sort by the helper column. Multiplying by 1 converts the extracted digits to real numbers, so that your sort makes sense. Hope this helps. Pete On Mar 25, 7:07*pm, Bridget wrote: I have 3 colums of information. One of the colums contains SSN's. I need to sort by the last 2 digits of the SSN and I can't seem to fiqure out how to do this. Any help would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting information within a cell.
On Mar 25, 2:07*pm, Bridget wrote:
I have 3 colums of information. One of the colums contains SSN's. I need to sort by the last 2 digits of the SSN and I can't seem to fiqure out how to do this. Any help would be greatly appreciated. Try this: In a new column, put this formula to show only the last two digits of SSN: =RIGHT(cell number,2) ~Where it says "Cell" simple left click once in the SSN cell that contains the number beside this formula. ~Where it shows the number "2", make sure and put a comma beside it and then the number two. Hope this helps. This should work on the numbers even if they have the dash inbetween the three sections of the SSN. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a column of information | Excel Discussion (Misc queries) | |||
Sorting Subtotaled information | Excel Discussion (Misc queries) | |||
formula help, sorting information | Excel Worksheet Functions | |||
sorting information on a template. | Excel Discussion (Misc queries) | |||
sorting two columns' information | Excel Discussion (Misc queries) |