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)

In the attached is what I think you're looking for.
In the Data sheet I've removed all but the raw data, that is no calculated columns.

In the sheet Missed I've put a formula in cell A2. This is all you need. The result spills down into the rows below. There is no need to copy this formula down:
In cell I2, is the same formula but it doesn't pick and choose the columns returned, it returns all the columns from the Data sheet. Delete this formula (and the headers in row 1), it's only there for your information and to let you check the filtering is correct.

I've done the same for the Gone and Work sheets.

Attached Files

msofficeforums503803Ifs.xlsx (16.6 KB, 2 views)

Thank you.

While this does work, I would have to format the sheets as tables manually (without using format as table).
If there is no option to do it within the framework I created I understand and will do so, but I'd prefer to have it using my tables.

In the future, this might contain up to 10000 rows.

Hard work, but see attached.

Attached Files

msofficeforums50380_3Ifs_v2.xlsx (21.2 KB, 2 views)

Fantastic! Thank you very much!