Forum Discussion
Attach a number count next to a record
I'm not sure how to ask this, so google isn't turning up helpful.... Essential, I have a list of items, and I need to identify the sequential number/count next to it...again, not sure how to ask in ...
Let's say the data are in cell A2 and down.
If the same values are always together, as in your example, enter the following formula in B2:
=IF(A2=A1, B1+1, 1)
If the values could be intermingled, enter the following formula in B2:
=COUNTIF(A$2:A2, A2)
In both cases, fill down from B2 to the end of the data.