Fixed column, variable rows
 

I need to name a cell, using a fixed column, column C & a variable row #:
The last row $ of column C (containing values), which changes everyday:

Today the last row # of column C containing values= #24. Tomorrow it'll be
#25...

I have another cell, cell: Y51, which uses a formula to calculate the last
row # of column C- containing values. Thus, today, cell: Y51 reads: 24.

I need to use the changing value from cell Y51(today=24) and column C, and
give these two values to a new cell, (Ex) cell T32.
Ex: Cell T32 would read: C(Y51), Instead of reading C24...

Fixed column, variable rows
 

=INDIRECT("C"&Y51)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in message
...
I need to name a cell, using a fixed column, column C & a variable row #:
The last row $ of column C (containing values), which changes everyday:

Today the last row # of column C containing values= #24. Tomorrow it'll be
#25...

I have another cell, cell: Y51, which uses a formula to calculate the last
row # of column C- containing values. Thus, today, cell: Y51 reads: 24.

I need to use the changing value from cell Y51(today=24) and column C, and
give these two values to a new cell, (Ex) cell T32.
Ex: Cell T32 would read: C(Y51), Instead of reading C24...

Fixed column, variable rows
 

Sir,
thank you for the answer. However, the result of the formula you provided,
I have already, from another formula used in cell Y51.

Perhaps I failed to express the question properly: I need for cell (Ex) T32,
to read
not only the result of that formula, in this case= 24, but the column letter
as well.
Ex: I want for cell T32 to result in: C24, not just 24.

I would appreciate your reply greatly.


"Bob Phillips" wrote:

=INDIRECT("C"&Y51)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in message
...
I need to name a cell, using a fixed column, column C & a variable row #:
The last row $ of column C (containing values), which changes everyday:

Today the last row # of column C containing values= #24. Tomorrow it'll be
#25...

I have another cell, cell: Y51, which uses a formula to calculate the last
row # of column C- containing values. Thus, today, cell: Y51 reads: 24.

I need to use the changing value from cell Y51(today=24) and column C, and
give these two values to a new cell, (Ex) cell T32.
Ex: Cell T32 would read: C(Y51), Instead of reading C24...

Fixed column, variable rows
 

So if Y51 has =INDIRECT("C"&X92) say you want to pick out the C as well as
its value?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in message
...
Sir,
thank you for the answer. However, the result of the formula you
provided,
I have already, from another formula used in cell Y51.

Perhaps I failed to express the question properly: I need for cell (Ex)
T32,
to read
not only the result of that formula, in this case= 24, but the column
letter
as well.
Ex: I want for cell T32 to result in: C24, not just 24.

I would appreciate your reply greatly.


"Bob Phillips" wrote:

=INDIRECT("C"&Y51)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in
message
...
I need to name a cell, using a fixed column, column C & a variable row
#:
The last row $ of column C (containing values), which changes
everyday:

Today the last row # of column C containing values= #24. Tomorrow
it'll be
#25...

I have another cell, cell: Y51, which uses a formula to calculate the
last
row # of column C- containing values. Thus, today, cell: Y51 reads:
24.

I need to use the changing value from cell Y51(today=24) and column C,
and
give these two values to a new cell, (Ex) cell T32.
Ex: Cell T32 would read: C(Y51), Instead of reading C24...

Fixed column, variable rows
 

To elaborate, I would need for the following to be answered:
Assume the following:
We have 3 columns: A, B, C.
A new row is added to all 3 columns daily, containing one of 3 possible
values:
Value 1 corresponds to column A, Value 2 cor. to col. B & Value 3 cor. to
col. C.
Only one value will exist per row. Thus, each row will contain either one of
Value 1,
or one of Value 2 or one of Value 3.
Assuming that Value 1 has been absent for 3 times (3 rows) currently, how
would you use a formula to calculate which is the last cell in column A in
which Value 1 appeared?
The answer to the above, would be used as the needed value to the
afforementioned formula and this answer, the result of this calculation, must
be used as a value, not a formula, (Ex) by using the INDEX function, in the
original- target- formula.

"Bob Phillips" wrote:

So if Y51 has =INDIRECT("C"&X92) say you want to pick out the C as well as
its value?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in message
...
Sir,
thank you for the answer. However, the result of the formula you
provided,
I have already, from another formula used in cell Y51.

Perhaps I failed to express the question properly: I need for cell (Ex)
T32,
to read
not only the result of that formula, in this case= 24, but the column
letter
as well.
Ex: I want for cell T32 to result in: C24, not just 24.

I would appreciate your reply greatly.


"Bob Phillips" wrote:

=INDIRECT("C"&Y51)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in
message
...
I need to name a cell, using a fixed column, column C & a variable row
#:
The last row $ of column C (containing values), which changes
everyday:

Today the last row # of column C containing values= #24. Tomorrow
it'll be
#25...

I have another cell, cell: Y51, which uses a formula to calculate the
last
row # of column C- containing values. Thus, today, cell: Y51 reads:
24.

I need to use the changing value from cell Y51(today=24) and column C,
and
give these two values to a new cell, (Ex) cell T32.
Ex: Cell T32 would read: C(Y51), Instead of reading C24...

Fixed column, variable rows
 

Mr. Phillips,
Thank you for your assistance in the matter. I found what I was looking for,
in an answer you provided to another person, regarding a similar subject.
I cannot but be impressed by the calibre of your expertise.

"Vasilis Tergen" wrote:

To elaborate, I would need for the following to be answered:
Assume the following:
We have 3 columns: A, B, C.
A new row is added to all 3 columns daily, containing one of 3 possible
values:
Value 1 corresponds to column A, Value 2 cor. to col. B & Value 3 cor. to
col. C.
Only one value will exist per row. Thus, each row will contain either one of
Value 1,
or one of Value 2 or one of Value 3.
Assuming that Value 1 has been absent for 3 times (3 rows) currently, how
would you use a formula to calculate which is the last cell in column A in
which Value 1 appeared?
The answer to the above, would be used as the needed value to the
afforementioned formula and this answer, the result of this calculation, must
be used as a value, not a formula, (Ex) by using the INDEX function, in the
original- target- formula.

"Bob Phillips" wrote:

So if Y51 has =INDIRECT("C"&X92) say you want to pick out the C as well as
its value?

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in message
...
Sir,
thank you for the answer. However, the result of the formula you
provided,
I have already, from another formula used in cell Y51.

Perhaps I failed to express the question properly: I need for cell (Ex)
T32,
to read
not only the result of that formula, in this case= 24, but the column
letter
as well.
Ex: I want for cell T32 to result in: C24, not just 24.

I would appreciate your reply greatly.


"Bob Phillips" wrote:

=INDIRECT("C"&Y51)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Vasilis Tergen" wrote in
message
...
I need to name a cell, using a fixed column, column C & a variable row
#:
The last row $ of column C (containing values), which changes
everyday:

Today the last row # of column C containing values= #24. Tomorrow
it'll be
#25...

I have another cell, cell: Y51, which uses a formula to calculate the
last
row # of column C- containing values. Thus, today, cell: Y51 reads:
24.

I need to use the changing value from cell Y51(today=24) and column C,
and
give these two values to a new cell, (Ex) cell T32.
Ex: Cell T32 would read: C(Y51), Instead of reading C24...