Count the number of distinct subsets of a string that match a criteria
I need to create a formula to count the number of distinct subsets of a string that match a criteria.
I have a sheet with a column foo. the foo column contains the following
I need a formula that looks at this column and returns the number of distinct A(s) which would be three in my example. One for A-Z, one for A-Y and one for A-X.
Thanks in advance,
Help Article Resources
Check out the Formula Handbook template!