Note:
In the sample above, the cell remains empty if there are no dates with this partner, or if no weekdays occur more than once (as MODE
works). I'm not sure whether you want a different behavior for these edge cases.
In the sample above, the cell remains empty if there are no dates with this partner, or if no weekdays occur more than once (as MODE
works). I'm not sure whether you want a different behavior for these edge cases.