Home / Excel / Tin học văn phòng / [Excel] Finding n-th match with INDEX and AGGREGATE (without array formula)

[Excel] Finding n-th match with INDEX and AGGREGATE (without array formula)

March 19, 2018 Excel, Tin học văn phòng

Formula: (tham khảo từ mrexcel.com)

=INDEX(B$2:B$10,AGGREGATE(15,6,(ROW(B$2:B$10)-ROW(B$2)+1)/(A$2:A$10=E2),F2))

[Excel] Finding n-th match with INDEX and AGGREGATE (without array formula)

[Excel] Finding n-th match with INDEX and AGGREGATE (without array formula)

Reviewed by Le Huy Hoang on March 19, 2018 Rating: 5

No comments:

Subscribe to: Post Comments ( Atom )