| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sorting
Put a single quote in front of false. False is being intrprete as the
logical FALSE which has a number equivalent instead a string and is being sorted by the number. "James Spencer" 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 |
|
#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 |
| Reply |
| 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) | |||
Linear Mode
