merge formulas?
 

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)

merge formulas?
 

It works just fine for me:

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

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


--
Biff
Microsoft Excel MVP


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)

merge formulas?
 

On Feb 22, 4:15 pm, "T. Valko" wrote:
It works just fine for me:

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

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

--
Biff
Microsoft Excel MVP



Yes, it works fine for me too, in some 40 cells. But I have just one
cell that is misbehaving. I can get the proper value by adding
together the formula split into two cells, so ideally I could merge
those cells and get the proper value in a single cell.