[Excel] Tìm kiếm trả về nhiều giá trị

MaxBong - Updated on March 23, 2021 - Post a Comment
Công thức:
H3=IFERROR(INDEX(B$3:B$13,AGGREGATE(15,6,ROW($1:$95)/($A$3:$A$13=$E$3),$G3),0),"")
I3=IFERROR(INDEX(C$3:C$13,AGGREGATE(15,6,ROW($1:$95)/($A$3:$A$13=$E$3),$G3),0),"")
Nguồn: VBA Excel Ứng Dụng
# excel
Share this post: pinterest