Extract multiple matches into separate rows, but with tables

Hi guys,

I almost have the INDEX SMALL formula correct, but I am missing one thing.. Hope someone sees it.



So the formula is from this page: https://exceljet.net/formula/extract...-separate-rows
{=IFERROR(INDEX(names,SMALL(IF(groups=E$4,ROW(names)-MIN(ROW(names))+1),ROWS($E$5:E5))),"")}




I want the list in a range (Starting in cell F11) and I get my value from a table, and my IF condition is from a table.



My formula is:
{=IFERROR(INDEX(reservering[Positie];SMALL(IF(reservering[status]="uploaden";ROW(reservering[Positie])-ROW(reservering[Positie])+1);ROWS($F$11:F11)));"")}

reservering[Positie] contains value I need
reservering status="uploaded" is my condition

Then comes the part where I screwed it up..

ROW(reservering[Positie])-ROW(reservering[Positie])+1);ROWS($F$11:F11)))




I should get 3 values back (because 3 have the "uploaden" condition. I do get 3 results back, but they are all from the same row.


Obviously, I messed up, can anyone see how I fix it?

You should be able to do it like this:

Please Login or Register  to view this content.

Entered as an array formula. Then do the same for the other columns.

WBD

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.