list certain row only when matching certain condition

[godlev]

Hi all,

again i need some help solving a formula.

i need to extract people which are assigned to certain task daily from a list of 100+

so i need a formula which will display the names and the schedule per those names which match certain condition

please see the example file display-results-matching-certain-condition.xlsx

[JBeaucaire]

On the results page:

1) I went into HOME > OPTIONS > ADVANCED and turned off zero values display
2) The formula in column A is an array. If you edit the ranges, confirm your edits with CTRL-SHIFT-ENTER to reactivate the array. You will see the curly braces appear { } on their own as an indication. (Do not edit that formula to entire columns, won't work)
3) The formula in B3 is the key formula copied down/across the table
4) The value in A1 is connected to the name of the sheet. By copying the sheet as a whole and naming the new sheet for a different condition (from column A on Schedule), the names will appear automatically for that condition

[godlev]

JBeaucaire - thank you, your suggestion will help my daily work, i have modified the code these days a little bit in order to adjust it - i just needed some time to get understand it.
THANK YOU!

[joshnathan]

Hello i'm trying to do something similiar is it possible to some how automatically extract this data set into a new set of cells so i can run a forumlae on it. My data range is dynamic and can change from 10 values to 100 within minutes.