Originally Posted by
Freightman
So, if I understand correctly, the “words” include the numbers, and that You want to find out how many times that *****12 appear, and how many times *****13 appear, not fuzzy matching *****12 and *****13, extracting the numbers and searching for ***** only, not that there’s anything wrong with that.
So, without altering the order of the alphanumeric characters, dump every text file (you don’t have to, just makes it easier), into column a, starting at A1, and making 1 long column. Then, in column b, starting at b1, the formula (I’ll test it later once I go to my basement office - it has been so long, im sure it’s off)
=if(countif,a:a>1,1)
This should list the number of occurrences of every unique alphanumeric. Single occurrences will display as 1, duplicate occurrences as 2, triples at 3 etc.
If this is what you’re looking for, let me know, and I will test and correct the formula.
Bookmarks