How to display a list based on the result of two searchcriteria (1 Viewer)

Stefan.Kauw

Registered User.
Local time
Today, 22:56
Joined
May 31, 2018
Messages
24
Hi!

I've struggeling a bit for a while now....
We have a big list of activities with different people responsible of executing these activities in a certain week.

You'll probably get it already... I'd like to search for the responsible and a certain week to display a list of the tasks meant for that person in that week.

Have been trying using the small, row and index trick with the array-formula brackets {} and i am able to sort out all activities for the responsibility. Unfortunately i cant seem to sort it out on the weeknumber.
If the activity should be done that week there will be a "x" displayed in the list of search result. Next step is to sort out the x's by using the same method i guess but this doesnt work at all while using almost the same formula.


Code:
{KLEINSTE(ALS(D3:D82=PL_ZOEK!$M$3;RIJ(D3:D82));$A3)-1}
 
Last edited by a moderator:

Users who are viewing this thread

Top Bottom