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     www.energyefficientbuild.com.   Jan-18-2016

post by: Nuclear Buckeye:

https://productforums.google.com/forum/#!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

https://docs.google.com/spreadsheets/d/1Vx9ugj4c4ho5wK1PPJhzfD8vxNc-WNi0yiVDeBYKeXw/edit?usp=sharing 

https://docs.google.com/spreadsheets/d/1Vx9ugj4c4ho5wK1PPJhzfD8vxNc-WNi0yiVDeBYKeXw/edit#gid=0

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.

---------------------------------------------------------------------------------------------------------------------

yogi_From Data In Table A16:E Compute The Most Productive Day (the day with fewest 'inc') In Column E

Google Spreadsheet   Post  #2023

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-15-2016

post by: Nuclear Buckeye:

https://productforums.google.com/forum/#!topic/docs/F8fhYOeU2aM;context-place=forum/docs

Find most productive day of the week - HELP!!!

I have a list of dates in A17:A in format eg, Sat. 16-Jan. 

I also have the categories for the type of work are in cells E17:E. One category is labeled "inc", short for incomplete.

How can I find the most common day of the week, eg. Wed or Tues, that I complete the work?

Desired Result format: Saturday, e.g.

(PS - cannot share spreadsheet since it has client info on it)

------------------------------------------------------------------------------------------------------------