I am trying to create Weekly charts using the closing price of each day. Column C has all the closing value prices. Column H has the Week number that I need the Open for. Column F has the weeknum for of the corresponding date. So for example, I4 shoudl equal 650.50 because it is the first value with a weeknum of "1", the open for I5 should be 656.72, etc..
Thanks in advance for any help.
Bookmarks