Y
Yunus
Gents, where am I going wrong...
The formula below only works upto Row 72 of Sheet1.
i.e it only works for Table array $K$5:$BT$72 not for '!$K$5:$BT$73 or
beyond.
Sheet 1 Contains the Table with an array of Dates
In Sheet 2 Cell B1=Today()
In Sheet 2 Cell B2= COUNTIF('Sheet1'!K5:BT138, "<"&TODAY())
In Sheet 2 Cell A5 copied down Column A is
=IF(ROWS($A$5:A5)>$B$2,"",INDEX('Sheet1'!$B$5:$B$138,INT(SMALL(IF
('Sheet1'!$K$5:$BT$138<$B$1,(ROW('Sheet1'!$K$5:$BT$138)-ROW('Sheet1'!$K
$5)+1)*10^5+COLUMN('Sheet1'!$K$5:$BT$138)-COLUMN('Sheet1'!$K$5)-1),ROWS
($A$5:A5))/10^5)))
In Sheet 2 Cell B5 copied down Column B is
=IF(ROWS($A$5:A5)>$B$2,"",INDEX('Sheet1'!$K$3:$BT$3,MOD(SMALL(IF
('Sheet1'!$K$5:$BT$138<$B$1,(ROW('Sheet1'!$K$5:$BT$138)-ROW('Sheet1'!$K
$5)+1)*10^5+COLUMN('Sheet1'!$K$5:$BT$138)-COLUMN('Sheet1'!$K$5)+1),ROWS
($A$5:A5)),10^5)))
Why does it only work for data only upto Row 72 . How can I determine
what the cause is.
The formula below only works upto Row 72 of Sheet1.
i.e it only works for Table array $K$5:$BT$72 not for '!$K$5:$BT$73 or
beyond.
Sheet 1 Contains the Table with an array of Dates
In Sheet 2 Cell B1=Today()
In Sheet 2 Cell B2= COUNTIF('Sheet1'!K5:BT138, "<"&TODAY())
In Sheet 2 Cell A5 copied down Column A is
=IF(ROWS($A$5:A5)>$B$2,"",INDEX('Sheet1'!$B$5:$B$138,INT(SMALL(IF
('Sheet1'!$K$5:$BT$138<$B$1,(ROW('Sheet1'!$K$5:$BT$138)-ROW('Sheet1'!$K
$5)+1)*10^5+COLUMN('Sheet1'!$K$5:$BT$138)-COLUMN('Sheet1'!$K$5)-1),ROWS
($A$5:A5))/10^5)))
In Sheet 2 Cell B5 copied down Column B is
=IF(ROWS($A$5:A5)>$B$2,"",INDEX('Sheet1'!$K$3:$BT$3,MOD(SMALL(IF
('Sheet1'!$K$5:$BT$138<$B$1,(ROW('Sheet1'!$K$5:$BT$138)-ROW('Sheet1'!$K
$5)+1)*10^5+COLUMN('Sheet1'!$K$5:$BT$138)-COLUMN('Sheet1'!$K$5)+1),ROWS
($A$5:A5)),10^5)))
Why does it only work for data only upto Row 72 . How can I determine
what the cause is.