Help with CountIF, Offset, Sequence, and rows function

[shellwig]

Thank you in advance for any help provided. I'm trying to create a helper column for my look up that provides a new sequence based on the cells.
See below for my formula and what I'm trying to accomplish. Based on many searches this was what I could find that could perform this function.
If there is a better way then I'm open to your suggestion.

Best Regards - Shamus

(a)	(b)	want to return	formula returns	formula
547	1101​	547-1101-1	547-1101-1	A2:A10&"-"&B2:B10&"-"&COUNTIF(OFFSET(A2:A10,0,0,SEQUENCE(ROWS(A2:A10))),A2:A10)
553	1101​	553-1101-1	553-1101-1
556	1101​	556-1101-1	556-1101-1
547	1201​	547-1201-1	547-1201-2
553	1201​	553-1201-1	553-1201-2
556	1201​	556-1201-1	556-1201-2
547	1250​	547-1250-1	547-1250-3
553	1250​	553-1250-1	553-1250-3
556	1250​	556-1250-1	556-1250-3

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=TEXTJOIN("-",,A2:B2,COUNTIFS(A$2:A2,A2,B$2:B2,B2))

 

[shellwig]

Thank you so much as it worked. I do not understand how it worked yet but I will soon enough. Again thank you so much for your help and I've updated my account to show which version I'm using.

 

[Fluff]

You're welcome & thanks for the feedback.