Forum Discussion
Ian_4-learnin
Apr 01, 2019Copper Contributor
Running count of matching numbers (or text)
Hello! I fear this may be a simple question, but I don't know how to phrase it correctly to find an answer. I cannot figure out how to calculate a running count for a row of items that have dupli...
- Apr 01, 2019
SergeiBaklan
Apr 01, 2019Diamond Contributor
Ian_4-learnin , that could be like
=(N(D2)+1)*($B3=$B2)+($B3<>$B2)
It adds 1 if the value in B is the same and returns 1 otherwise
- Ian_4-learninApr 01, 2019Copper Contributor
SergeiBaklanThank you, that works great. Now I just have to study a little and figure out what it means...