hi, i made a project to count the number of row based on value. in short, the method is to read the current cell and the next cell, if it’s the same then count + 1, if it’s different then the current and next cell will move down. something like this
it’s been working good so far. But recently the data is getting much bigger, it even take days to finish the process with my current method. Is there a more efficient way to do this ?