M
Michelle Tucker
The formula below is working brilliantly thanks to everyone who helped!
Last problem to fix...
If "*MT*" is in more than one cell, is there a way for it do show the result
as the first cell and then a / and then the second cell?
=IF(COUNTIF(D24
28,"*MT*"),INDEX($A24:$A28,MATCH("*MT*",D2428,FALSE)),"DAY OFF")
Last problem to fix...
If "*MT*" is in more than one cell, is there a way for it do show the result
as the first cell and then a / and then the second cell?
=IF(COUNTIF(D24
28,"*MT*"),INDEX($A24:$A28,MATCH("*MT*",D2428,FALSE)),"DAY OFF")