HI Everyone
I have been searching for a solution but I cant find one.
What I have in a sheet is the following
A1 0 B1 0 C Dog, so the formula will bring back Dog or could be a1 Dog b1 0 c1 0, the formula would bring back dog again. Only one of the cells will ever have text the other two will always be 0
Thanks for any help
Bookmarks