Would like to sort on cell formulas

D

Dallman Ross

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
 
C

CLR

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
 
B

Bruce Sinclair

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?
Click to expand...

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.
 
D

Dallman Ross

Bruce Sinclair said:
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 ... :)
Click to expand...

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
 
B

Bruce Sinclair

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/
Click to expand...

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!
Click to expand...

I understand. Best of luck :)
 
D

Dallman Ross

Dallman Ross <dman@localhost.> said:
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?
Click to expand...

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
 
Top