Hello and thank you to all who reads this !
- I have the following code for a heads or tails macro that counts the consecutive heads or tails in column A then places the answer in Column B.
- What I need is a column C that only has the consecutive number of times Tails occurred, while column B only has the consecutive number of times Heads occurred
- The code below places both consecutive numbers in the same column
Please Login or Register to view this content.
Not sure if your column A is populated with "Heads" and "Tails" or "H" and "T" but this will work for either scenario
Please Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
Holy Jesus in the morning it works great !!! Thankyou thankyou!
One last thing: The first row has headers, how do you start the count in row 2
I have tried several combinations i.e. "A2:A" and I cannot get it to work correctly. It is placing a value in row 1 where it should be blank because the headers are there.
Aloha
try changing this line
i = 1
to
i = 2
Geez, so simple but complex , I read that somewhere but never applied it . Thankyou very very much !
Aloha
Geez, so simple but complex , I read that somewhere but never applied it . Thankyou very very much !
Aloha
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks