| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting formula cells not same as sort of value cells? Yikes!
Type the letter b in A1, the letter a in A2.
C1=A1 C2=A2 Now if you highlight and sort A1:A2 ascending, it is alphabetized. Undo it if you've done this. If you highlight and sort C1:C2 ascending, it does not sort as desired. This is in XL2003. I assume that you reproduce it; thanks for reporting that you don't. But if you do - this is shocking. In sick irony this is a case where hope I have a corrupt file. Surely this is not by design??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting blank cells with a formula in them | Excel Discussion (Misc queries) | |||
| Yikes! Merged cells making life miserable. | Excel Discussion (Misc queries) | |||
| Formula for sorting a range of cells in decending order | Excel Discussion (Misc queries) | |||
| I can't sort data when the key column cells contain formula | Excel Discussion (Misc queries) | |||
| Sorting merged cellsHow do I sort merged cells not identically siz | Excel Worksheet Functions | |||
Threaded Mode
