hm...

Moin again,

I need your help once more:

I want 3 sheets to be filled with data from one table, if certain conditions are met (all Yes or No).
The conditions are "Success", "Kids", "Missed" or "Gone". Only "Missed" and "Gone" are to be separated.
To achieve this I created a helping condition "Work" which checks if either "Missed" or "Gone" are true. So if both are "No" the data entered should be visible in the sheet "Work".
If either of the others is "Yes", the data should be seen in the corresponding sheet, so either "Missed" or "Gone".

I did this once in the past, but I'm drawing blanks for 4 days straight now.

See the attached file for more info.

Edit: If I do a simple =IF(tData[@Work]="No","",INDEX(tData Process],[@DataRow])) I get the right data into the first row in "Work", but I also get empty rows, which I don't want.

Kind regards,
Jack

Attached Files

3Ifs.xlsx (15.2 KB, 4 views)