Sequentially Numbering Repeated Values

JCluff

I have sheet where Group AAA is listed 50+ times then group BBB, CCC, etc.. What formula can be used to sequentially number the Groups like pictured below?

Thank you!

Paul Newcome

If you already have row numbers present, you can use something like this:

=COUNT(DISTINCT(COLLECT(Group:Group, [Row #]:[Row #], @cell<= [Row #]@row)))

Steven Stikons

Hi,

Leave row 1 of your sheet blank and begin your Group values on row 2. Then use the following formula in cell [Group #]2 and copy it down:

=IF(Group@row = Group1, [Group #]1, [Group #]1 + 1)

Hope this helps.

Steven

JCluff

Thanks @Steven Stikons. Do you or anyone else know if this is possible without a blank row? I have another column that is providing row #s, and this solution creates some additional challenges to work around.

Paul Newcome

If you already have row numbers present, you can use something like this:

=COUNT(DISTINCT(COLLECT(Group:Group, [Row #]:[Row #], @cell<= [Row #]@row)))

JCluff

Thanks as always @Paul Newcome!

Paul Newcome

Happy to help. 👍️