Hi,

supposing you have the weeks starting from column B, use following formula
in column A and drag it down.

=OFFSET(B2,0,MATCH("*52*",$1:$1,0)-2)

What it will do, it will go ahead and pickup the week 52 data.
You might need to change the week in the formula as per your preference.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)


New Delhi, India


"kevcar40" wrote:

Hi
I have a table of data starting at week 1(b) and going to week 52(Ab)
what i would like to do is find the last week (using week number)
copy only that column of data to be pasted else where

any ideas

thanks

kevin