find cell value

[kevcar40]

hi
i have this formula that identifies the last column with data in it.

=ADDRESS(35,MATCH(6.022*10^23,33:33))

this works a treat

what i would like to do is us the result of this and subtract 3 column
of it
ie
ADDRESS(35,MATCH(6.022*10^23,33:33)) = N35

i would like to have a formula that takes N35 and sub tracts 3
columns fro it giving K33
i then intend making that my range
ie k12:n33 and copy the data else where to work on


thanks

kevin

 

[Bernard Liengme]

If =ADDRESS(35,MATCH(6.022*10^23,33:33)) returns $N$35
then =ADDRESS(35,MATCH(6.022*10^23,33:33)-3) will return $K$35
best wishes

 

[kevcar40]

If    =ADDRESS(35,MATCH(6.022*10^23,33:33))    returns $N$35
then =ADDRESS(35,MATCH(6.022*10^23,33:33)-3) will return $K$35
best wishes

Thank you very much