You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I need to know how many A's, B's, C', etc there are, because want to know how many times I need to cut out each letter for jersey's.
MIKE
NORMA
PAUL
M = 2
I = 1
K= 1
E = 1
N = 1
O = 1
A = 2
etc....
What formula do I use?
MacBook Air, macOS 15.1
Use CONCAT to concatenate all the names into one long string and COUNTMATCHES to count the occurrence of each letter
Formula in Table 2::B1 =COUNTMATCHES(CONCAT(Table 1::B),$A1)
Fill down to complete the column
Use CONCAT to concatenate all the names into one long string and COUNTMATCHES to count the occurrence of each letter
Formula in Table 2::B1 =COUNTMATCHES(CONCAT(Table 1::B),$A1)
Fill down to complete the column
I am looking to find out how many times each letter is listed
