How to fix the cell value

  • Thread starter Thread starter cgx79
  • Start date Start date
C

cgx79

Hi,
I hv a table below see if anybody can help...


Cell A1 to A2 hv a formula =$C$1
but if i copy cell a1 n a2 to a3 n a4 i will hv =$c$3
The result i 1 is $c$2 and not $c$3. Is there anyway to do this...
cos i nit 2 c1 for first 2 cell n c2 for the next 2 n so on...


A B C
==========
1=$c$1
2=$c$1
3=$c$3
4=$c$3
5=$c$5
6=$c$5
7

This is the result i 1 to get

A B C
==========
1=$c$1
2=$c$1
3=$c$2
4=$c$2
5=$c$3
6=$c$3
 
Hi
not quite sure but try the following formula in A1
=INDIRECT("C" & GANZZAHL((ROW()-1)/2)*2 + 1)
and copy down
 
From the context, I would guess:

=INDIRECT("C" & INT((ROW()-1)/2)*2 + 1)

I've already told him that I'm jealous that he can think in two languages at
the same time.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


Hi Frank,

just curious, what's "GANZZAHL" ?? in
 
Thanks, RagDyeR ! LOL

Always knew one could pick up much more
stuff than just Excel in these newsgroups <g>

... but I don't think the result of the formula
was what the OP wanted

The formula:
=INDIRECT("C" & INT((ROW()-1)/2)*2 + 1)
Click to expand...

gives the equivalent of:

=C1
=C1
=C3
=C3
=C5
=C5
etc

while the OP wanted

=C1
=C1
=C2
=C2
=C3
=C3
etc
 
Hi Max
1. forgot the translation: gANZZAHL (german) = INT

2. I misread the OP.
For the OP try
=INDIRECT("C" & INT((ROW()-1)/2) + 1)
 
To tell you the truth, I don't know what the OP is really looking for.

If what you say is true, then all they have to do is eliminate the
absolutes, type in the first four cells, and then simply select all four,
and drag down to copy as needed.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Thanks, RagDyeR ! LOL

Always knew one could pick up much more
stuff than just Excel in these newsgroups <g>

... but I don't think the result of the formula
was what the OP wanted

The formula:
=INDIRECT("C" & INT((ROW()-1)/2)*2 + 1)
Click to expand...

gives the equivalent of:

=C1
=C1
=C3
=C3
=C5
=C5
etc

while the OP wanted

=C1
=C1
=C2
=C2
=C3
=C3
etc
 
I can't believe I said that!

Another senior moment.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

To tell you the truth, I don't know what the OP is really looking for.

If what you say is true, then all they have to do is eliminate the
absolutes, type in the first four cells, and then simply select all four,
and drag down to copy as needed.
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------

Thanks, RagDyeR ! LOL

Always knew one could pick up much more
stuff than just Excel in these newsgroups <g>

... but I don't think the result of the formula
was what the OP wanted

The formula:
=INDIRECT("C" & INT((ROW()-1)/2)*2 + 1)
Click to expand...

gives the equivalent of:

=C1
=C1
=C3
=C3
=C5
=C5
etc

while the OP wanted

=C1
=C1
=C2
=C2
=C3
=C3
etc
 
Back
Top