Hello all -

I have a particularly tricky function that I'm troubleshooting by
splitting the parts into different cells. I have the various cells
adding up correctly, but still i have a typo or some problem in the
original cell formula.

Is there a way I can merge the formulas in cells? For instance, if I
have

Column U
=COUNTIF(Q$10:$Q10,$Q10 )-1

Column W
=RANK($Q10,$Q$10:$Q$29)

Column X
=U10+W10

I would like for column X to become:

COUNTIF(Q$10:$Q10,$Q10 )-1 + RANK($Q10,$Q$10:$Q$29)

The "merging" of formulas is logical only in you intend for one formula to
use the result of another formula in its calculations. Otherwise it doesn't
make sense to do so. HTH Otto
wrote in message
...
Hello all -

I have a particularly tricky function that I'm troubleshooting by
splitting the parts into different cells. I have the various cells
adding up correctly, but still i have a typo or some problem in the
original cell formula.

Is there a way I can merge the formulas in cells? For instance, if I
have

Column U
=COUNTIF(Q$10:$Q10,$Q10 )-1

Column W
=RANK($Q10,$Q$10:$Q$29)

Column X
=U10+W10

I would like for column X to become:

COUNTIF(Q$10:$Q10,$Q10 )-1 + RANK($Q10,$Q$10:$Q$29)

On Feb 25, 10:20 am, "Otto Moehrbach"
wrote:
The "merging" of formulas is logical only in you intend for one formula to
use the result of another formula in its calculations. Otherwise it doesn't
make sense to do so. HTH wrote in message


That's exactly what I'm looking for. So is it possible to do?

The "merging" of formulas is logical only in you intend for one formula
to
use the result of another formula in its calculations. Otherwise it
doesn't
make sense to do so. HTH wrote in message

That's exactly what I'm looking for. So is it possible to do?

Did you try looking in the other newsgroup you posted this question to?

Rick

On Feb 25, 1:26 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
The "merging" of formulas is logical only in you intend for one formula
to
use the result of another formula in its calculations. Otherwise it
doesn't
make sense to do so. HTH wrote in message

That's exactly what I'm looking for. So is it possible to do?

Did you try looking in the other newsgroup you posted this question to?

Rick

I just checked it out, thanks.

I'm just looking for a simple "Yes, you can; right click on the cell
and choose 'merge formulas'..." or "No, you can't, but what is it that
you're trying to do in the first place? Why don't you just..." So far
nobody has given me a yes or no answer.

wrote in message
...
On Feb 25, 1:26 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
The "merging" of formulas is logical only in you intend for one
formula
to
use the result of another formula in its calculations. Otherwise it
doesn't
make sense to do so. HTH wrote in message

That's exactly what I'm looking for. So is it possible to do?

Did you try looking in the other newsgroup you posted this question to?

Rick

I just checked it out, thanks.

I'm just looking for a simple "Yes, you can; right click on the cell
and choose 'merge formulas'..." or "No, you can't, but what is it that
you're trying to do in the first place? Why don't you just..." So far
nobody has given me a yes or no answer.

No, there is no "merge formula" feature.

You've said that the formula works on all but one row but you haven't
defined what "doesn't work" means.

--
Biff
Microsoft Excel MVP