Would like to sort on cell formulas
 

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

Would like to sort on cell formulas
 

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

Would like to sort on cell formulas
 

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.

Would like to sort on cell formulas
 

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

Would like to sort on cell formulas
 

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 :)

Would like to sort on cell formulas
 

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