As title,
Have a roster of employees' information, I want to have in the list of state is set to 0 and 1. If it is 0 means leaving if is 1 said on-the-job, if is 0, the whole row data, according to the second list can be? Consult!

CodePudding user response:

To filter out the copy to the second table

CodePudding user response:

Array formula:

reference

=index (sheet1! A: A, small (if (sheet1! $B $2: $B $100=1, the row ($2: $100), 4 ^ 8), row (A1)))

Lose the formula press CTRL + shift + enter three formula

CodePudding user response:

Last attachment, directly will give you fill in the formula,

CodePudding user response:

Do the pivot table, do you departure on-the-job field filter field, it is good to refresh every time