Hello, i’m trying right now to find out if 2 users have common disponibilities. I thought i could count the intersection of 2 list of ranges in order to do that but it seems not working as intended.
I tried this formula :
Unfortunatly, this works only if both of the users in the comparaison or the same.
Here’s a pic of the database:
When I try to compare manually with the following formula, it works.
I tried to merge with the formula :
and here is the result (seems to duplicate)
What i am doing wrong ?
If you need more informations, let me know !
Thank you in advance