IsabellaLearning
Board Regular
- Joined
- May 23, 2009
- Messages
- 115
Hi all,
I am doing a roster to cover sleepovers at mums place as she is unwell.
Column C contains my brothers availability
Column D contains my availability
availability is text "Sleep @ Mums"
In Column E I want to add the text"COVERED" IF either column C OR column D contains the text "Sleep @ Mums"
Also if both column C and column D contain "sleep at mums" on same line" text to say "duplicate"
Would be most appreciative!
Thanks
Izzy
I am doing a roster to cover sleepovers at mums place as she is unwell.
Column C contains my brothers availability
Column D contains my availability
availability is text "Sleep @ Mums"
In Column E I want to add the text"COVERED" IF either column C OR column D contains the text "Sleep @ Mums"
Also if both column C and column D contain "sleep at mums" on same line" text to say "duplicate"
Would be most appreciative!
Thanks
Izzy