If i have a list of 100 true/false statements is there a way i could count how many times true repeats two times in a row also 3 times in a row and so on?
For an example if i have a list:
true
false
true
true
false
true
true
true
false
true.
In example above true appears once in a row three times , two times in a row once and three times in a row once.
Thank you.
Enter your data in Column A starting at A2.
Formula for B2 =IF(LOWER(A2)<>"true","",IF(LOWER(A1)="true",B1+1,1))
Formula for C2 =IF(LOWER(A2&A3)="truefalse",B2,"")
Copy B2 to C2 and fill down.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
im geting "there is a problem with your formula" error
Try replacing commas (,) with semi-colons (in the formulae, as required by your locale in Belgrade:
Formula for B2 =IF(LOWER(A2)<>"true";"";IF(LOWER(A1)="true";B1+1;1))
Formula for C2 =IF(LOWER(A2&A3)="truefalse";B2;"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Great
Thank you both
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks