Thread: [Solved] Have an alphbetical list need to count how many names start with A, B, C etc.
View Single Post
 
Old 09-02-2014, 08:30 AM
jolivanes jolivanes is offline Windows XP Office 2007
Advanced Beginner
  
Join Date: Sep 2011
Posts: 91
jolivanes will become famous soon enough
Default
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
Reply With Quote