Forum Discussion
Autopopulate formula across worksheets?
I am trying to create a lunch schedule for the year with approx 30 people. Each day a new person will be chosen (with their initials on Picture 1), and then it will automatically rotate (s...
alternatively:
=TRANSPOSE(FILTER( _DATES_, CHOOSEROWS( _SCHEDULE_, XMATCH( _NAME_, _NAMES_)<>"", "")where _DATES_, _SCHEDULE_, and _NAMES_ are the corresponding ranges on sheet1 and _NAME_ is the name to look up