XcelLearner
Board Regular
- Joined
- Feb 6, 2016
- Messages
- 52
- Office Version
- 365
- 2016
- Platform
- Windows
Hi,
I have a value looking problem that is out of my depth, and would appreciate your help.
I have a data set in array L5:O28 as in the photo, with the return of each month. Investment B1 was first made in 6/30/2021 and therefore only captured the return since July 2021. I will have investment B2, B3, and so on as the array will expand, but let's keep it at L5:O28 at the moment.
I have a desired result array in Q5:T28 to report the monthly return of Investment B1. The month was recorded as 1 for Jan, 2 for Feb, etc. Any date before the Investment was made in 6/30/2021 should be returned as a blank like in the photo. What is the formula for that (cell S6), so that if I change the Investment to B2, it will change as well?
I use Office 365.
Thank you very much.
I have a value looking problem that is out of my depth, and would appreciate your help.
I have a data set in array L5:O28 as in the photo, with the return of each month. Investment B1 was first made in 6/30/2021 and therefore only captured the return since July 2021. I will have investment B2, B3, and so on as the array will expand, but let's keep it at L5:O28 at the moment.
I have a desired result array in Q5:T28 to report the monthly return of Investment B1. The month was recorded as 1 for Jan, 2 for Feb, etc. Any date before the Investment was made in 6/30/2021 should be returned as a blank like in the photo. What is the formula for that (cell S6), so that if I change the Investment to B2, it will change as well?
I use Office 365.
Thank you very much.