Colm C contains str's such as
The first char is the UNIT, search for Unit 1, needed to look for all in col c that first char was a 1.
the conditional (E4:E12>"") was looking for if a string had been entered in those cells or if it was still blank. colm E would have a User name entered if that work was complete. The Search was for Unit 1 AOV type valves where work was indicated completed by user name entry.
Incidently, in the formula
what do the -- mean?
how does it differ from