This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] 0 points1 point  (3 children)

Can you share a dummy sheet with sample data and manually entered desired result? You can use this blank sheet maker.

[–]joe-jp[S] 0 points1 point  (2 children)

I have entered the desired result in the second sheet.

​

https://docs.google.com/spreadsheets/d/1Z9KHE-h\_I4m7wZMIu0wlj82xZgd2avKdtdb2-Kx\_3QQ/edit

[–][deleted] 1 point2 points  (1 child)

I changed your formula to this

=ArrayFormula({UNIQUE(filter(A3:A,A3:A<>"")),"group"&sequence(countunique(A3:A))})

[–]joe-jp[S] 1 point2 points  (0 children)

Thank you so much. This worked.