+ Reply to Thread
Results 1 to 1 of 1

Finding the Open in an Array of Data

  1. #1
    Registered User
    Join Date
    07-23-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    1

    Finding the Open in an Array of Data

    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.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1