Google Sheets - Formula for most frequent day of the week

Hello,

In the attached file - sheet 1 shows the day of the week that a user was created and which week number of the year this was.

What I'm trying to get in the summary sheet is how to calculate which was the most popular day that users were created per week.
i.e if there were 100 sign ups in week 40 and 90 of those were created on a Wednesday then K4 should say Wed

Thanks in advance!

Book2.xlsx

Thanks for your quick reply.

What we really need is one line to show what the busiest day is for each week rather than a sumproduct. Was hopefully trying to avoid having to sort/filter.

I didn't however account for an equal results, but this shouldn't occur in the future...

Originally Posted by janmorris

How do you work out that there were "100 sign ups in week 40 and 90 of those were created on a Wednesday" when there is NO such data in Sheet1 attributed to week 40?

As it seems difficult to get valid sample data, i have expanded the summary, with working solution.

https://docs.google.com/spreadsheets...#gid=787575188

Sorry that was just i.e./hypothetical the full data set is here
Book2.xlsx

Thank you for this - but I'm trying to avoid the filter method as we'll end up having hundreds of lines on a sheet that's already quite full of data/stats. But maybe what we need isn't possible in sheets..