Hello,
I am attempting to write a formula that will list the dates someone has taken holidays from a work rota. I'm not 100% sure the best way to go about this in fact I'm not entirely sure if it's possible at all with the current layout of the rota.
I am thinking possibly an INDEX/MATCH formula with an IF statement but I could be thinking about this in the wrong way.
I'll attach two images to the post of the rota the list needs to pull the data from and what I would like the end game list to look like, would really appreciate if someone could point me in the right direction or if I'm wasting my time attempting to make this work.
I want the formula to be able to recognize the "H" in the row which corresponds with the person and reference the date above in the list.
I hope this all makes sense!
I am attempting to write a formula that will list the dates someone has taken holidays from a work rota. I'm not 100% sure the best way to go about this in fact I'm not entirely sure if it's possible at all with the current layout of the rota.
I am thinking possibly an INDEX/MATCH formula with an IF statement but I could be thinking about this in the wrong way.
I'll attach two images to the post of the rota the list needs to pull the data from and what I would like the end game list to look like, would really appreciate if someone could point me in the right direction or if I'm wasting my time attempting to make this work.
I want the formula to be able to recognize the "H" in the row which corresponds with the person and reference the date above in the list.
I hope this all makes sense!