find cell value

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

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
 
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
 
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
Click to expand...
Thank you very much
 
Back
Top