We check with an Excel spreadsheet how often someone visits a shop. We calculate how often someone visited the shop on a Monday, Tuesday etc. I have a formula which works.
Excel should display the most visited day of a week. I use a MAX() to check for the highest number. It can happen that there isn't a a most visited day. Maybe there are two ore more Max() numbers. My formula displays the first highest day of the day only. It should display both or more days.
Have a look Walmart: The most visited days are Tuesday and Friday. What should I do in order for (example) cell C3 to display the names "Thursday" and "Friday".
I have attached my spreadsheet to this question.
Thanks in advance for your help.