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.

09-02-2014, 08:30 AM

jolivanes

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

Office 2007

Advanced Beginner

Join Date: Sep 2011

Posts: 91

Cathy
The following line

Code:

Cells(j, 4).Formula = "=COUNTIF(RC[-2]:R[" & lr & "]C[-2],RC[-1] & ""*"")"    '<----- Column D has formula

needs to be changed to this

Code:

Cells(j, 4).Formula = "=COUNTIF(R1C[-2]:R[" & lr & "]C[-2],RC[-1] & ""*"")"    '<----- Column D has formula

It should be =COUNTIF(R1 instead of =COUNTIF(R
The 1 (one) needs to be there.
Good luck

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 12:18 AM.