I need a formula that will tell me the day of the week used most frequently by an individual. I have an example of the worksheet. I don't think this is too terribly difficult compared to other formulas i made for this sheet but i for some reason can't figure this one out right now. Thanks for the help.
Last edited by Intern13; 09-09-2010 at 04:18 PM.
If you change the formula in J3 and across to =WEEKDAY(J4), then in H5,
=MODE(IF(J5:AGJ19>0, J$3:AGJ$3))
... confirmed with Ctrl+Shift+Enter
Entia non sunt multiplicanda sine necessitate
I'm getting the #Value! with that formula.
Did you change the formula in J3 and across?
Did you confirm the formula in H5 with Ctrl+Shift+Enter instead of just Enter?
Note: If there is no MODE value, #N/A is returned. (e.g. if the employee used 3 days, Monday, Wednesday and Friday, there is no mode)
I didn't confirm. I got it now. Now that gives me a number which I'm assuming corresponds to a day of the week. Great thank you!
You can format that cell as Custom using dddd and it will show you the day of week name instead of number.
Please remember to mark this thread as Solved. Thanks!
Where would i put the dddd in the equation?
You don't put it in the equation. You right-click the cell and choose Format Cells. Select Custom as the category and set the Type to: dddd
Right. I knew that duh. Thanks for all the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks