Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Suppose I have 6Y,3M in one cell 6Y,7M in another cell and 6Y,10M in another
cell.While I am sorting in descending order 6Y,10M shoul come first then 6Y,7M, then 6Y,3M should come. But in my case 6Y,10M comes last.But if I am inserting one 0 my problem can be solved ,but without this how can it be done.Or If I have to insert 0 , how this process be automated by using any function.becauz I have lots of data , so 0 cann't be inseted manually. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) | |||
sorting error | Excel Worksheet Functions |