Dear team,
I am having date list on Sheet "schedule" column A and i am using formula on Column W for displaying all the rows continuously.
My formula is =IFERROR(INDIRECT("A"&SMALL(IF($A$3:$A$34<>"",ROW($A$3:$A$34),FALSE),ROW()-1)),"")
The above formula is working up to row 34 only. I want to extend the row till 1500.
If i change the value to =IFERROR(INDIRECT("A"&SMALL(IF($A$3:$A$1500<>"",ROW($A$3:$A$1500),FALSE),ROW()-1)),"") it is not displaying my dates.
Kindly check rectify my problem.
I am attaching my fie here for your reference