Yeah! An Excel thread!
I'm trying to count all cells containing the value A*. Unfortunately for me, looking up a value with an asterix after it counts all cells with an A and then any other characters after it (Aardvark, AA, Angie Dickinson etc). I know there's a way round this, but I'm very tired and can't think of it right now. Can you help?