79182479
Date: 2024-11-12 19:34:06
Score: 2
Natty:
You may try:
=LET(a,TOCOL(C7:E27,1),SORT(UNIQUE(ARRAYFORMULA(TOCOL(a,1)+TOCOL(ARRAYFORMULA(6-TOCOL(ARRAYFORMULA(WEEKDAY(a)),1)),1)))))
Output:
Reference
Reasons:
Posted by: Gyul - Probably link only (1):
- Low length (1):
- Has code block (-0.5):
- Low reputation (0.5):