G
Guest
I have Data in Cell A10 and I want it to automatically go into cell A30.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
In A30 enter:
=A10
=A10
G
Guest
I forgot to tell you that A30 has a formula in it. Will it still work if I
just put =A10?
just put =A10?
P
Peo Sjoblom
You can't both have the cake and eat it! Why would you automatically get the
value of A10 in A30 and what does the formula in A30 do?
value of A10 in A30 and what does the formula in A30 do?
G
Guest
Ok. The formula counts the cells above.
Peo Sjoblom said:You can't both have the cake and eat it! Why would you automatically get the
value of A10 in A30 and what does the formula in A30 do?
G
Guest
I'm confused as well. So you want the formula currently in A30 (count of the
cells above) AND the value in A10 to both be displayed in A30? If so, you
would have to concatenate the values together some how, like:
=CONCATENATE(<formula currently in A30>," ",A10)
cells above) AND the value in A10 to both be displayed in A30? If so, you
would have to concatenate the values together some how, like:
=CONCATENATE(<formula currently in A30>," ",A10)
P
Peo Sjoblom
What result would you expect to get when you want to count the cells above
and then get A10
You can concatenate like this
=Existing formula in A30&" "&A10
replace Existing formula etc ...with whatever you got already which will
give you both values as text in the same cell
and then get A10
You can concatenate like this
=Existing formula in A30&" "&A10
replace Existing formula etc ...with whatever you got already which will
give you both values as text in the same cell