ceneiqe
asked on
Create a macro: formula to show count how many consecutive alphabet in a spreadsheet
See attached sheet.
Consecutives-count.xls
I need to show the following :
Column P to have a show how many times "A" occured consecutively for 3 times
Column Q to show how many times "A" occured consecutively for 6 times
Column R to show how many times "A" occured consecutively for more than 6 times
Consecutives-count.xls
I need to show the following :
Column P to have a show how many times "A" occured consecutively for 3 times
Column Q to show how many times "A" occured consecutively for 6 times
Column R to show how many times "A" occured consecutively for more than 6 times
ASKER
"Please note that the second "A" in about the third line had a space in it... so was in error..."
I didn't see any error. Consecutives-count--1-.xls
Which exact cell are you refering to ?
Is it possible to run auto by pressing alt f8 and run ?
I didn't see any error. Consecutives-count--1-.xls
Which exact cell are you refering to ?
Is it possible to run auto by pressing alt f8 and run ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This allows you to select what you are looking for and how many times to triger the count...
Open in new window
Please note that the second "A" in about the third line had a space in it... so was in error...maybe a find replace " " to correct this on all or changing the If c.Value = Letter Then to If c.Value like "*" & Letter & "*" Then will fix that.
Consecutives-count.xls