I want to count how many times there is an occurrence of all 8 possible "W/L" & "1,2,3"-scenarios (i.e. WWW, WWL, WLW, WLL, LLL, LLW, LWL,& LWW).
So in this case there should be 2 "WWW", 1 "WLW", 1 "LLW", 1 "WLL" & 1 "LLL"
My spreadsheet looks like this: (columns A & B)
A B
1 W
2 W
3 W
1 W
2 L
3 W
1 L
2 L
3 W
1 W
2 L
3 L
1 L
2 L
3 L
4 W
1 W
2 W
1 W
2 W
3 W
Am I correct that you only count the first 3 cells together and then the next 3 cells together? So not the first to the third and then the second to the fourth?
When I say semicolon, u say comma!
Short answer "yes". Long answer I would like to "reset" the count with each "1" in column A. For example, at the bottom of my example there are 6 consecutive "W"s, but I would only like to "count" the one string of "WWW" that is across from column A's "1", "2", "3".
Ah got it. If you want this all in one formula, I wouldn't know how (but it's probably possible). If you are OK with adding helper columns, I think I can help you...
If you fill a helper column (say C) with this formula (and drag down), then you can use a simple countif to count the different instances
=IF(AND(A1=1,A2=2,A3=3),B1&B2&B3,"")
Wow! Amazing. Thanks so much!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks