Warning: Trying to access array offset on value of type null in /www/wwwroot/app-pack.telkomuniversity.ac.id/wp-content/themes/sinrato/functions.php on line 40
Re: Array data report
In A6 of each worksheet
=IFERROR(INDEX(Data!B$1:B$100, AGGREGATE(15,6,1/(–$H$1=Data!$A$1:$A$100)ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),””)
In B6
=IFERROR(INDEX(Data!C$1:C$100, AGGREGATE(15,6,1/(–$H$1=Data!$A$1:$A$100)ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),””)
and drag them down till end of the form
In A6 of each worksheet
=IFERROR(INDEX(Data!B$1:B$100, AGGREGATE(15,6,1/(–$H$1=Data!$A$1:$A$100)ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),””)
In B6
=IFERROR(INDEX(Data!C$1:C$100, AGGREGATE(15,6,1/(–$H$1=Data!$A$1:$A$100)ROW(Data!$A$1:$A$100),ROW()-ROW($A$5))),””)
and drag them down till end of the form
