Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In , Dallman Ross <dman@localhost.
spake thusly: I suppose this would be via a macro, and that's fine. My goal is to sort a table based on the formulas in one column, rather than on the displayed results in the column. Can anyone help with this? I just figured out one way to do this easily. Indeed, I'm surprised nobody suggested it, in this clever group. If I do, e.g., from a macro, a search-and-replace of the leading "=" with some benign unique char in the column I intend to sort, the formulas become text. I can sort as desired, then replace the dummy chars with "=" again. Voila! Dallman Ross |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort text that is deliminated within a cell | Excel Discussion (Misc queries) | |||
How to sort but keep linked formulas? | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |