Hi,
im using the below array formula to bring all data from column B with date as the criteria but when I use the same code for a second date on the same sheet no data is visible.
=IFERROR(INDEX(Sheet3!$B$3:$B$100,SMALL(IF(Sheet2!$A$1=Sheet3!$A$3:$A$100, ROW(Sheet3!$B$3:$B$100) -2,""),ROW()-2)),"")
the worksheet is setup so there is a merged date row and then a column header row below that then the data which is around 9 rows from the headers row.
there is a second date merged row below for the next date which is the one im having issues.
im using the below array formula to bring all data from column B with date as the criteria but when I use the same code for a second date on the same sheet no data is visible.
=IFERROR(INDEX(Sheet3!$B$3:$B$100,SMALL(IF(Sheet2!$A$1=Sheet3!$A$3:$A$100, ROW(Sheet3!$B$3:$B$100) -2,""),ROW()-2)),"")
the worksheet is setup so there is a merged date row and then a column header row below that then the data which is around 9 rows from the headers row.
there is a second date merged row below for the next date which is the one im having issues.