find cell value
 

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

find cell value
 

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

find cell value
 

On 17 Mar, 13:15, "Bernard Liengme"
wrote:
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 MVPhttp://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
Thank you very much

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- Hide quoted text -

- Show quoted text -