LinkBack URL
About LinkBacks
I have a list of names for my wedding and am making place cards out of scrabble pieces and need to know how many times each individual letter appears in the 150names to know how many of each letter to buy
I have a list of names for my wedding and am making place cards out of scrabble pieces and need to know how many times each individual letter appears in the 150names to know how many of each letter to buy
If you have names in A2:A200 then try listing each letter of the alphabet in C2 down and use this formula in D2 copied down for a count of each letter
=SUMPRODUCT(LEN(A$2:A$200)-LEN(SUBSTITUTE(A$2:A$200,C2,"")))
Audere est facere
Cheers thankyou,
The formula worked, only problem is it didnt include capital letters so i had to do another column and just add the two together Thanks
Did you try the suggestion in reply #3?
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try this...
Data Range
This formula entered in D2 and copied down:
=SUMPRODUCT(LEN(A$2:A$7)-LEN(SUBSTITUTE(UPPER(A$2:A$7),C2,"")))
Yes, SUBSTITUTE function is case-sensitive so I should have included UPPER or LOWER function to deal with that
Tony's suggestion covers that
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks