| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
Hi,
Column A has the following data ABCD02052008 ABCD02062008 ABCD2062008 ABCD262008 u can make something in the above data i.e, after the text there are numbers which are in date format ie.,02nd may 2008, 02nd june 2008, 2nd june 2008 & 2nd june 2008 How do I sort based on months ? Actually in col B I used =mid(a1,7,2) from this i can able to get result but for the 3rd cell & 4th cell i am not getting what i need.... Is there any other formula to get the result ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| sorting SS# | Excel Discussion (Misc queries) | |||
| Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
| sorting | Excel Discussion (Misc queries) | |||
| Sorting | Excel Discussion (Misc queries) | |||
Threaded Mode
