|Posted by:||Pete (psower…@murton-view.freeserve.co.uk)|
|Date:||Sat, 19 Jul 2008|
I use the following formula to calculate if any of the Cells in
J21:J28 include categories from the PlannedDowntime named range.
Is there anyway I can do a search from within J21:J28 as above for
part of a string. I would like to look for the word "Trial" in J21:J28
but the Cell may contain "Trial Paper Break" or "Trial Dryer Jam"