Home > Back-end >  Returning mode day only if criteria is met
Returning mode day only if criteria is met

Time:06-16

enter image description here

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.

  • Related