Guys I need some help with a complex problem
I have a roster and I wish to formulaically find a name and return iteratively the seven work days (across in columns) then find the name again in the next week (further down the rows) and return the next seven days. With the result being a single column list of all shifts
Proving very difficult. What a horrible way to display data
Please and thankyou for any advice you can share it will be HUGELY helpful
I have a roster and I wish to formulaically find a name and return iteratively the seven work days (across in columns) then find the name again in the next week (further down the rows) and return the next seven days. With the result being a single column list of all shifts
Proving very difficult. What a horrible way to display data
Please and thankyou for any advice you can share it will be HUGELY helpful