| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can i sort on a perticular column for odd and even numbers
Column1 0021D8B9B5FE 0021D8B9B494 001FCAE8A6B1 0021D8B9B6BF 001FCAE88DEE 0021D8B9AD96 001FCAE8A9C8 0021D8B9B5F7 0021D8B9B90E 0021D8B9B758 I want to sort on the last digit on each value: for example: 0021D8B9B5FE If last digit start with 1,3,5,7,9,a,c,e (consider this odd numbers) if last digit start with 2,4,6,8,0, b,d (sondifer this even) So how can I sort each raw based on the last character being odd or even in excel. =thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to sort a column of Randomly selected numbers? | Excel Worksheet Functions | |||
| how do I sort a column mixed with odd and even numbers .. ? | Excel Discussion (Misc queries) | |||
| HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED | Excel Discussion (Misc queries) | |||
| sort and return column numbers | Excel Worksheet Functions | |||
| sort a column of numbers with 100510 and 10160 so they are in th. | Excel Discussion (Misc queries) | |||
Threaded Mode
