[EXCEL] Tìm và lấy dữ liệu ra bảng riêng bằng INDEX, AGGREGATE

Công thức Cell H6
=IFERROR(INDEX($B$6:$B$16;AGGREGATE(15;6;(ROW($B$6:$B$16)-ROW($B$5))/($B$6:$B$16=$H$3);ROWS($B$6:B6)));"")
=IFERROR(INDEX($B$6:$B$16;AGGREGATE(15;6;({1;2;3;4;5;6;7;8;9;10;11})/{TRUE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE};1));"")

AGGREGATE(15;6; ARRAY; k)

AGGREGATE(15;6;(ROW($B$6:$B$16)-ROW($B$5))/($B$6:$B$16=$H$3);ROWS($B$6:B6)));””)

15: small
6: Error ignore
ARRAY = ROW($B$6:$B$16)-ROW($B$5))/($B$6:$B$16=$H$3)
= {1;2;3;4;5;6;7;8;9;10;11})/({TRUE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE}
={1;#DIV/0!;#DIV/0!;4;#DIV/0!;#DIV/0!;#DIV/0!;8;#DIV/0!;#DIV/0!;#DIV/0!}
k = ROWS($B$6:B6) = 1, 2, 3…

INDEX(ARRAY,Row,Column)

ARRAY = Mã hàng
Row = AGGREGATE = 1, 4, 8…
Column = 1