I'm looking for a formula to match a text within an array and return the results found.
I know how to you use vlookup/match/index formula's, but I can only return the first match found. I would like to return the first match in cell A1 and the second match inside A2, third inside A3, etc.
So when the first match is found and placed inside A1 then the formula inside A2 should ignore the first match that is already found and show the next match value.
I would like to get this done with a formula and not with the autofilter option inside Excel.
Solved by A. W. in 29 mins