Is it possible to make an if statement look into an entire column and count every time that same cell matches. For example:
I have a large list of names in column A and an even longer list of names in column C. Every time the name in A1 shows up in column C I want that count to show up in B1 (ie: if A1 shows up 20 times in Column C I want the number 20 to show up in B1).
What formula whould I have to put in B1 to get this count?
Thanks in advance!
Bookmarks