In the attachment, you'll see there are a series of numbers. Some are repeated throughout the column. I'd like to set up a formula to find out how many times a certain number repeats. For example, "1a" repeats 4 times throughout the column, "2a" 9 times, etc... Tried a =COUNTIF(A2:A11,"1a") but just returns 0.
Much appreciated!
Bookmarks