Thread: [Solved] Have an alphbetical list need to count how many names start with A, B, C etc.
View Single Post
 
Old 08-31-2014, 07:08 AM
cadonn cadonn is offline Windows XP Office 2007
Novice
  
Join Date: Jan 2013
Posts: 6
cadonn is on a distinguished road
Default Have an alphbetical list need to count how many names start with A, B, C etc.
Have an alphbetical list need to count how many names start with A, B, C etc. I know I can use the =COUNTIF(A1:A50, "*A") but I do not want to have to do this for each letter of the alphabet. Is there another option. I am using Excel 2010. Thank you.

Cat
Reply With Quote