| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting
We use a custom formatted number ##-####-## I need to be able to sort by
the middle four digits for a report. Can someone help me please? I have done it before, but I am having a brain freeze. Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting
Use another column with formulas like:
=mid(a1,4,4) and then sort your data by that column. tcidawn wrote: We use a custom formatted number ##-####-## I need to be able to sort by the middle four digits for a report. Can someone help me please? I have done it before, but I am having a brain freeze. Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting
You could create a Helper column
=MID(A1,4,4) then sort by that column "tcidawn" wrote: We use a custom formatted number ##-####-## I need to be able to sort by the middle four digits for a report. Can someone help me please? I have done it before, but I am having a brain freeze. Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting
=--MID(A1,4,4) "tcidawn" wrote: We use a custom formatted number ##-####-## I need to be able to sort by the middle four digits for a report. Can someone help me please? I have done it before, but I am having a brain freeze. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
| Sorting Data in ascending order | Excel Discussion (Misc queries) | |||
| sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
| Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
| sorting number in ascending order | Excel Discussion (Misc queries) | |||
Linear Mode
