Monday, January 18, 2016

yogi_Compute Instance Of Most Occurring Weekday For Tasks In E20:E For Categories Specified In B1:E1

Google Spreadsheet   Post  #2025
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-18-2016
post by: Nuclear Buckeye:!mydiscussions/docs/F8fhYOeU2aM
Find most productive day of the week - HELP!!!
from post 0f 10:21 AM Jan-18-2016

Thanks for the help so far.... I'm lost (as H***) as to how to use array formula and queries... you guys are too good.

I'm sharing a dummy sheet (sorry, didn't think of making a dummy sheet)

I have the categories up in Row 1. I actually want the most frequently reoccurring day, for each category

Cells B5:F5 are editable. I cleared a lot of it out to make it less busy.

Also, if possible, to have Cell F5 also since it'll be the best overall day of the week.