Hello all,
I am currently working on a form that will automatically pull in only dates that fit a certain criteria. On the first page, as soon as it is opened, the current month and year fill in, this then sets the calendar on a separate sheet and assigns it the crew that will be working. I have set logic to place "True" to the right of ONLY the last day of a crews rotation and "False" to the right of all other days. On the first sheet I would like to recall every instance of "True" so that I have only the dates that are associated to the last week of that crews rotation.
the cells I am pulling the data TO are B6:B17
The date I want returned is =Sheet2!C3:C33
the instance I am looking for "True" is =Sheet2!E3:E33
what is the best way to do this? I can get the first instance using =INDEX(Sheet2!C3:C33,MATCH("True",Sheet2!E3:E33,0)) but am unsure as how to pull only the next instance of "True". etc. etc. ANY HELP?
Bookmarks