How can I count the cells in a range who’s contents are contained in a larger string?
returns #VALUE!, or ERR:511 as an array formula
the cells are blank or have a letter.
Application: Count railroad cars by destinations in a yard. A single character indicates the destination, and I want to know how many cars I have for a train I must build which brings cars to multiple destinations. Next I want to highlight those cars (cells), to help sort.WO.ots