Hi,
I have a time series for a portfolio, where rows reflect individual tickers and columns reflect dates. My goal is to populate column BF on the attached, which represents the first instance of a date being 0 (working backward from column BD).
In cases where the most recent date is 0, I'd like to display N/A in column BF, and in cases where no 0 exists, I'd like to revert back to the very first date (column C). I'm still pretty new, but it seems like that this might all be accomplished utilizing an IF statement, however, my question was more about the structure of the loop when the first condition is true.
I'm still in debugging mode, but the way the code is written now, it continues to print the addresses of cells that equal 0 beyond the first one. How can i structure the code so that it only picks up the very first 0, then moves on to the next row (i.e., in the first row example on the attached, it would print AO11 as the address and subsequently move to row 12).
So far, I have the below:
Appreciate any and all help. Thanks.
Bookmarks