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?

Thanks,
Dallman Ross

Use a Helper column in which you put the same formulas, but without the
leading Equal sign......then sort on that column.

hth
Vaya con Dios,
Chuck, CABGx3



"Dallman Ross" wrote:

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?

Thanks,
Dallman Ross

In article , Dallman Ross <dman@localhost. wrote:
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 saw someone recommend an add in that had a function to 'capture' a
formula as a string. Seems to me that this + a sort would do what you want
... now ... if I could just find where I read that ... :)

Hope someone can point you at the add in I mean.

In , Bruce Sinclair
spake thusly:

In article , Dallman Ross
<dman@localhost. wrote:

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 saw someone recommend an add in that had a function to
'capture' a formula as a string. Seems to me that this + a sort
would do what you want .. now ... if I could just find where I
read that ... :)

If you mean the MOREFUNC collection, I posted about it here
earlier today (late yesterday; it's 2 a.m. here now). I
found out about it a couple of weeks ago from others here
in this group. http://xcell05.free.fr/

Yes, it does have a function that shows the formula as text.
Theoretically, that would help me do this. But I am trying
to avoid setting up a dummy column like that. That's why
I was hoping someone could cobble a quick macro together
to do it instead.

I do appreciate the brainstorming, in any case!

Dallman

In article , Dallman Ross <dman@localhost. wrote:
In , Bruce Sinclair
z spake thusly:

In article , Dallman Ross
<dman@localhost. wrote:

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 saw someone recommend an add in that had a function to
'capture' a formula as a string. Seems to me that this + a sort
would do what you want .. now ... if I could just find where I
read that ... :)

If you mean the MOREFUNC collection, I posted about it here
earlier today (late yesterday; it's 2 a.m. here now). I
found out about it a couple of weeks ago from others here
in this group. http://xcell05.free.fr/

Ah ...right ... yep ... that would be it. I picked it up and installed it
myself today ... but didn't click that that may well have been where I saw
it. Bother !
Sorry about that chief :)

Yes, it does have a function that shows the formula as text.
Theoretically, that would help me do this. But I am trying
to avoid setting up a dummy column like that. That's why
I was hoping someone could cobble a quick macro together
to do it instead.
I do appreciate the brainstorming, in any case!

I understand. Best of luck :)

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