Hello
Below are 4 columns. ALL DATE, PRICE, MARKET OPEN and CLOSE. ALL DATE has all of the dates in the year. MARKET OPEN has dates where the stock market was open. CLOSE has the closing prices for a stock. I Would like the PRICE column to produce the CLOSE prices on the days where there is a MARKET OPEN and place an “N/A” on dates where the market is closed.
These are the four columns:
| ALL DATE | PRICE | MARKET OPEN | CLOSE | |||||||||||||||||||||||||||||||||||||||
|
2000-01-01 | 24.50 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-02 | 2000-01-02 | 25.15 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-03 | 2000-01-04 | 24.94 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-04 | 2000-01-05 | 24.75 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-05 | 2000-01-06 | 25.31 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-06 | 2000-01-07 | 25.18 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-07 | 2000-01-08 | 24.84 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-08 | 2000-01-10 | 25.09 | ||||||||||||||||||||||||||||||||||||||||
| 2000-01-09 | ||||||||||||||||||||||||||||||||||||||||||
|
2000-01-10
End result should look like:
What formula should I put into the PRICE column for this to work? Any help would be very much appreciated. |
By: Jesse