• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Getting latest week data out of total week data

Hi,


In Book every week new data is incorporated with data of old week.


I want to get the data of only latest week in separate book without opening file.


For example total data for file consist of data of week 47 + all past week data(week 1 to 46).


I want to extract items of week 47 in another file.


Note: Here i am converting Dates in to week by using =WEEKNUM formula.


Regards,

Pragnesh
 
Hi Pragnesh,


Try Vlookup(max(Entire_Date_Column),Data_Table,Req_Col_Num,FALSE).


key to formula is your lookup value which pulls max value of weeknum formula. This would obviously be the latest weekvalue/datevalue.


Regards,

Prasad
 
Hi,


Thanks it is very good thought.


Also i want to change weekNum setting.


My week start form Thursday and end on Wednesday.


How can i change week settings so that weeknum come as per my requirement?


Regards,

Pragnesh
 
Back
Top