Hello,
I am trying to replicate an excel count if formula. The difference with this is I want to count all items down a list, but nothing above. See below attachment for illustration
In this example, the count on 2135658HFA is 3 (in total). but by the second one, the count excludes the one above. so there are only 2 to count. Then on the last it becomes 1, as it excludes the 2 above.
Essentially, i want to allocate a "1" next to the LAST unique concat 2.
Please help!!!
Thanks