I have a pretty basic start on a schedule but I'm stuck on how to limit the number of times a week can be picked, I would like to limit it to 7, Also I'd like a summary on the second tab listing who picked what week.
Any suggestions?
I have a pretty basic start on a schedule but I'm stuck on how to limit the number of times a week can be picked, I would like to limit it to 7, Also I'd like a summary on the second tab listing who picked what week.
Any suggestions?
Perhaps this will be a start.
Helper columns (which may be moved and or hidden for aesthetic purposes) are added to the summary sheet.
Column P counts the number of times a week has been chosen using: =COUNTIFS(Choices!E$3:M$55,A2)
Column R lists those weeks that have been chosen less than 7 times using:Formula:Please Login or Register to view this content.
The contents of column R are now assigned to the named range "list1" which is used in data validation.
I have played with an idea as to how fill the summary sheet and have managed as far as filling in the "selected by" columns using:Formula:Please Login or Register to view this content.
I haven't figured out how to fill the "choice#" columns and will try to come back to that unless someone else has solved first.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Here is the completed formula for "Selected by" and "Choice#" on the Summary sheet:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
that works great thank you so much for the help.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks