Hello everyone!
I currently have a template that contains employee names and what I am looking to do is exclude any cell that would contain the word D/C infront of an employee's name, ex: D/C John Smith...I've tried many different functions and I haven't been able to figure it out, I've even tried to remove the slash, just in case it was affecting the formula, but still nothing. I've even tried to do the COUNTIF function, but I haven't yet been able to figure anything out.
I am currently using the COUNTIF function and the COUNTBLANK function in order to exclude all of the cells that contain the words NOT REQUESTED and exclude the cells that are blank, and this is currently working great! My formula looks like this:
=COUNTIF('MONDAY-TUESDAY'!C:C,"<>*NOT REQUESTED*")-COUNTBLANK('MONDAY-TUESDAY'!C:C)
I've tried replacing the NOT REQUESTED with the word D/C, but it's not working...
Any input would be greatly appreciated.
Thank you in advance