Return multiple matches- INDEX -FILTER Excel functions

This video shows how to find multiple matches in Excel and return the 1st, 2nd and nth instances using INDEX and FILTER functions. Returning multiple instances is always challenging, but the dynamic arrays in Excel make it easier
Workbook can be found here
docs.google.co...
#INDEX
#FindMultipleMatches
#FilterFunction

[@Neoscarface6342]

Top g

[@claudiaayala9654]

Absolutely brilliant thank you so much.

[@ExcelMoments]

You are welcome

[@ilolita_]

Needed this!!!

[@ExcelMoments]

That's good to know

[@edohanggoro4459]

Are there any possibilities to do same if we are using excel 2016?

[@ExcelMoments]

Yes there are, but it would not be pretty though 😀😀

[@nonoobott8602]

Great video and use case. Thanks for sharing
P.S.I didn't see my name on your MVP list column 😭😭😅

[@ExcelMoments]

Hahaha..my name was not there either 😄😄 Thanks for the feedback. I appreciate your comments always

[@GodsonFH]

🔥🔥🔥🔥

[@ExcelMoments]

Thanks

[@SafkatIslam-nq4pl]

nice

[@ExcelMoments]

Thanks