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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 04:02 AM.