help me to add new criteria in this array

[ACALEX]

i need another way with array.. this is correct but i need something else.. want first criteria in "B3" NAME.. and after that if i want to add DATE START and DATE END ..
thanks for help

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[FDibbins]

Try this ARRAY formula...
=IFERROR(IF(ROWS(B$7:B7)>$E$3,"",INDEX(db!A$2:A$26,SMALL(IF(db!$A$2:$A$26>=$C$3,IF(db!$A$2:$A$26<=$D$3,IF(db!$B$2:$B$26=$B$3,ROW(db!$A$2:$A$26)-ROW(db!$A$2)+1))),ROWS(B$7:B7)))),"")

You could also use Data Validation in B3 to make sure the names are spelled correctly, and only names in the list are used.

[ACALEX]

thenks for help.. and suggestions.. this change worked for me.. :D

[FDibbins]

Happy to help