I have created a sheet that somewhat shows what I'm working with.
The file shows only top 9 rows of 20k rows of real file. So you know it is a pretty large sheet
The format is similar and also if you look at it by hiding gridlines, it will be easier to see the borders defining each sections.
There are multiple sections in each row.
A section contains the columns (A-F) then next section starts (G-L), then so on.
First column in section "abc" doesn't really matter what it is but it defines start of new section.
Second column in section is "+" which I use to find out if whether to evaluate the following or not. (more on what to evaluate - which is what I need help with)
Third column to six column has either blank, "a", "b", or "c".
<--I need help with this-->
For all the sections with "+" in second column,
I need to count how many combinations of:
"a" & "" & "" & ""
"a" & "" & "" & "a"
"a" & "" & "" & "b"
"a" & "" & "" & "c"
"a" & "" & "a" & "a"
"a" & "" & "a" & "b"
occurs
I'm tried countifs but the file becomes very slow to open and save and calculate.
So I'm looking for a way of doing so without formula. Possibly with vba array.
testsheet.xlsb
Bookmarks