Forum Discussion
Counting chunks within a row
Hi! I have a really simple spreadsheet that has X's and empty cells. I know its super simple to count how many times X's appear, however, I want to return results that count each "chunk" of cells...
Thank you, Part of the reason I am on here is I am not super familiar with this stuff. I did copy and paste it but unless I am to put this into a VBA module, I am unclear why the formula is on 12 rows?
The formula has just been posted with linebreaks to aid readability; it's not intended to be on 12 lines. After you've copied it, make sure you click into the actual cell before pasting, or else paste it into the formula bar at the top. Again, suggest we use the test data you supplied and assume it is in A1:AG1 for now; we can then modify ranges after you're happy that it's working for that test case.