Have an alphbetical list need to count how many names start with A, B, C etc.

		Microsoft Office Forums > Microsoft Excel > Excel
Have an alphbetical list need to count how many names start with A, B, C etc.

FAQ

Thread Tools

Display Modes

08-31-2014, 07:08 AM

cadonn

Windows XP Have an alphbetical list need to count how many names start with A, B, C etc.

Office 2007

Novice

Join Date: Jan 2013

Posts: 6

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Right Click menu list names	jimbassett	Word	0	02-25-2013 02:39 PM
How to import a list of names into PowerPoint from Excel?	CarpetRemnant	PowerPoint	4	12-07-2012 11:08 AM
auto insert names from list for printing	andreipopa2k	Word	1	12-09-2011 01:51 PM
Using a list of names in credits effect	Pemberton	PowerPoint	4	08-17-2010 02:10 AM
Random names from a given list	professor snape	Excel	1	06-06-2009 09:39 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 PM.