| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
i think true and false not sorted ?
So put ' (single quote before that words- 'true ) and now it will sort...... On Apr 12, 12:20*pm, James Spencer <James wrote: I have a kist of names one of which is TRUE. When I sort the list alpabetically this name does not sort properly. Can anyone help. I'm assuming it's something to do with the TRUE function as the word FALSE does not sort also. There are people with the name TRUE. James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
| Sorting | 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
