Hi i wonder if you can help,

if i have a column starting with say A5, and have a row, could say starting with B6.... how do i get excel to find the intersection of the row and the column?... ie to find the cell A6?

Your help would be much much much appreciated,

James

I don't understand, James - a column will start with the first cell in it,
i.e. A1 for column A, and a row will start with the first cell in that, i.e.
A6 for row 6.

Are the cell references you quote contained in some other cells as text
values somewhere?

Please explain your requirement more clearly.

Pete


"James shaw" wrote in message
...

Hi i wonder if you can help,

if i have a column starting with say A5, and have a row, could say
starting with B6.... how do i get excel to find the intersection of the
row and the column?... ie to find the cell A6?

Your help would be much much much appreciated,

James




--
James shaw

=ADDRESS(ROW(B6),COLUMN(A5))
--
David Biddulph

"James shaw" wrote in message
...

Hi i wonder if you can help,

if i have a column starting with say A5, and have a row, could say
starting with B6.... how do i get excel to find the intersection of the
row and the column?... ie to find the cell A6?

Your help would be much much much appreciated,

James




--
James shaw

Hello James:

I'm not sure but I think this is what your looking for.

Thanks so so so so so much!