insert specific rows from a table into a second table with condition

[vadim_g]

Hello,

I have 2 excel file : one which detail of each piece, and one which detail each machine.

and

I want to copy on first excel, the rows of the second excel only if the rows is "ok" and only specific rows. The specific rows of the second excel is choosed like that : the value of the piece must be contained in the value of the begin and the end piece. Sorry for my english, better with the result that i want :

Thanks a lot

[v-jayw-msft · Accepted solution]

Hi @vadim_g ,

Please check the formulas:

operator = IF(Table1[ok/nok] = "ok",CALCULATE(MAX(Table2[operator]),FILTER(Table2,Table1[piece]>=Table2[begin piece]&&Table1[piece]<=Table2[end piece])))

machine = IF(Table1[ok/nok] = "ok",CALCULATE(MAX(Table2[machine]),FILTER(Table2,Table1[piece]>=Table2[begin piece]&&Table1[piece]<=Table2[end piece])))

Best Regards,

Jay