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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"kevcar40" wrote in message
...
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