Need variable that refers to same row different column
 

Background.:
I came up with this for a coworker-

Plug this formula into your B Column on the sheet of your report.

Formula:

=DATEVALUE(GXX)

where XX is the corresponding row value in column G


It would have been a lot cooler to send him a formula that he didn't have to
change.

Question.:
Is there a variable I can use in Excel that refers to the same row as the
selected cell, something like "=DATEVALUE(Gsamerow)" ???

TIA

Need variable that refers to same row different column
 

=DATEVALUE(INDEX(G:G,ROW())) is one option.
--
David Biddulph

"Toddomation" wrote in message
...
Background.:
I came up with this for a coworker-

Plug this formula into your B Column on the sheet of your report.

Formula:

=DATEVALUE(GXX)

where XX is the corresponding row value in column G


It would have been a lot cooler to send him a formula that he didn't have
to
change.

Question.:
Is there a variable I can use in Excel that refers to the same row as the
selected cell, something like "=DATEVALUE(Gsamerow)" ???

TIA

Need variable that refers to same row different column
 

I'm not sure I followed you - but you may check the INDIRECT Function.
=INDIRECT("G"&ROW())
Micky


"Toddomation" wrote:

Background.:
I came up with this for a coworker-

Plug this formula into your B Column on the sheet of your report.

Formula:

=DATEVALUE(GXX)

where XX is the corresponding row value in column G


It would have been a lot cooler to send him a formula that he didn't have to
change.

Question.:
Is there a variable I can use in Excel that refers to the same row as the
selected cell, something like "=DATEVALUE(Gsamerow)" ???

TIA

Need variable that refers to same row different column
 

I assume you understood my suggestion - in any case the full formula is:
=DATEVALUE(INDIRECT("G"&ROW()))
Micky


"מיכאל (מיקי) אבידן" wrote:

I'm not sure I followed you - but you may check the INDIRECT Function.
=INDIRECT("G"&ROW())
Micky


"Toddomation" wrote:

Background.:
I came up with this for a coworker-

Plug this formula into your B Column on the sheet of your report.

Formula:

=DATEVALUE(GXX)

where XX is the corresponding row value in column G


It would have been a lot cooler to send him a formula that he didn't have to
change.

Question.:
Is there a variable I can use in Excel that refers to the same row as the
selected cell, something like "=DATEVALUE(Gsamerow)" ???

TIA