I have a list of cells with text. I want to count how many times each unique text cell appears. However, countif is having trouble accurately distinguishing between unique cells
Ex:
ALLSTATE INSURANCE CO.VAN??
ALLSTATE INSURANCE CO.VANIL
If I were to ask it how many times ALLSTATE INSURANCE CO.VAN?? appeared in this range of two cells, it would tell me 2, although the correct answer is obviously 1. Is there a character limit for countif? Why is it missing this simply calculation?
Bookmarks