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