Pls help me solve this query with vlookup,
i have mentioned my query in detail in the excel file attached.
Detail added by moderator:
Query - I want weekly high, low , close of these 60 stocks
weekly high - low - close means high of entire week, low of entire week. Close of last working day of the week
I have daily bhavcopy data of all stocks from 1st aug 2018 in "BHAVCOPY" TAB
please help me with VLOOKUP or any formula,
Please note : the data in "BHAVCOPY" tab is daily data, and I need weekly high, weekly low, and weekly close of these 200+ stocks
Please help me with the solution
Bookmarks