New Member
October 18, 2021
I hope this will be a interesting challenge. Which could be the formulas from C2 to N8 to obtain years -separated by comma- that have the same days of the week distribution in their months. For instance, in C2 should appear: 1978, 1984, 1989, 1995
YEAR I | JANUARY | FEBRUARY | MARCH | APRIL | MAY | JUNE | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | DECEMBER | |
1970 | 1 on Sunday | ||||||||||||
YEAR F | 1 on Monday | ||||||||||||
2000 | 1 on Tuesday | ||||||||||||
1 on Wednesday | |||||||||||||
1 on Thursday | |||||||||||||
1 on Friday | |||||||||||||
1 on Saturday |
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Interesting challenge, indeed, but not clear unfortunately. Where are those years coming from? (1978, 1984, 1989, 1995)
that have the same days of the week distribution in their months
Column names are month names, not dates, how do you suggest to find the days of the week in a text string? We should just identify all Mondays from example, for that specific month name?
Please provide a more clear sample file, you can attach it here.
1 Guest(s)