Stefan.Kauw
Registered User.
- Local time
- Today, 02:55
- 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.
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: