Apr 01 2019 11:51 AM
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 duplicates. I've attached an example. I'm trying to calculate the highlighted row. I'm trying to get pivot tables to do it for me, but using the Running count function I just get a bunch of 1s.
Any help is appreciated!
Apr 01 2019 12:52 PM
@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
Apr 01 2019 01:22 PM
SolutionApr 01 2019 01:22 PM
@Sergei BaklanThank you, that works great. Now I just have to study a little and figure out what it means...
Apr 01 2019 01:22 PM
Solution