Using HLOOKUP and MAX functions to find the most commonly occurring weekday in a list

[mriddell93]

Hi all,

I'm trying to create a single-line formula that will count the day of the week (from a list) that occurs most commonly. The catch is that I MUST use the MAX and HLOOKUP functions together in the formula.

My outline defines it as so: "On the first worksheet develop a single line formula using the HLOOKUP and MAX functions to find the day of the week with the maximum number of customers."

Attached is the spreadsheet of data. I'm attempting to do this for the days of the week from Column D (Scheduled Day).

Thanks