TheJonWithNoH
New Member
- Joined
- Sep 8, 2017
- Messages
- 30
I have a formula which is copying data and repeating it numerous times in column B in a worksheet:
=IF(ISBLANK(INDIRECT("Sheet1!B"&ROW(B2))),INDIRECT("Sheet2!B"&(ROWS($B$2:B2)-(COUNTA(Sheet1!B:B)-2))),Sheet1!B2)
This formula is achieving part of what I am looking for, but now I need to list dates in column A starting with today. The dates will repeat until it reaches the end of the other repeating list and then the next day will start. For Example:
11/15/2017 Data1
11/15/2017 Data2
11/15/2017 Data3
11/16/2017 Data1
11/16/2017 Data2
11/16/2017 Data3
11/17/2017 Data1
11/17/2017 Data2
11/17/2017 Data3
How can this be achieved?
=IF(ISBLANK(INDIRECT("Sheet1!B"&ROW(B2))),INDIRECT("Sheet2!B"&(ROWS($B$2:B2)-(COUNTA(Sheet1!B:B)-2))),Sheet1!B2)
This formula is achieving part of what I am looking for, but now I need to list dates in column A starting with today. The dates will repeat until it reaches the end of the other repeating list and then the next day will start. For Example:
11/15/2017 Data1
11/15/2017 Data2
11/15/2017 Data3
11/16/2017 Data1
11/16/2017 Data2
11/16/2017 Data3
11/17/2017 Data1
11/17/2017 Data2
11/17/2017 Data3
How can this be achieved?