Hello,
I need to count "grouped" cells with values as one. Column "I" has bunch of 1's and 0's if it was on or off. I already deleted all the 0's and was left with 1's and empty cells in between. For example:
<tbody>
</tbody>
This has 3 "groups" so the end count would be 3.
To do it manually I would press CTRL+Down Arrow twice (once to reach the first cell with content, the second one to reach the last cell with content) and that would count as 1 "group."
If you guys need more information I'm glad to explain further. The excel file (per day) contains around 200K rows , it's like a log file that records every 300ish milliseconds..
I need to count "grouped" cells with values as one. Column "I" has bunch of 1's and 0's if it was on or off. I already deleted all the 0's and was left with 1's and empty cells in between. For example:
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
<tbody>
</tbody>
This has 3 "groups" so the end count would be 3.
To do it manually I would press CTRL+Down Arrow twice (once to reach the first cell with content, the second one to reach the last cell with content) and that would count as 1 "group."
If you guys need more information I'm glad to explain further. The excel file (per day) contains around 200K rows , it's like a log file that records every 300ish milliseconds..
Last edited: