Formula helper Column Join two cell and Countif first, second, third etc.

[Lukma]

Hi friend
Am Having a Challenge in creating a helper column of Joining Column A & Column C and the same time count for the first, second, and third, etc..

The problem is that each MUS No. is for different activities so I need it when it gets to a different MUS No the Name in Column C should count from the Start again

I have placed examples in my Data of what i need a formula to Join and Count in Column D

Appreciate assistance from Friends

Regards

MUS No	Vessel Name	Location	Helper Column Join Formula Example
MUS-1	A-RANGER	Rig Mehzem	MUS-1 & Rig Mehzem 1
MUS-1	A-RANGER	Rig Al Noof	MUS-1 & Rig Al Noof 1
MUS-1	A-RANGER	Rig Mehzem	MUS-1 & Rig Mehzem 2
MUS-1	A-RANGER	Rig SMS Essa	MUS-1 & Rig SMS Essa 1
MUS-1	A-RANGER	Rig Yemillah	MUS-1 & Rig Yemillah 1
MUS-1	A-RANGER	Barge Lulwa	MUS-1 & Barge Lulwa 1
MUS-2	LCT-TARFFAH-1	Bu Sikeen Island	MUS-2 & Bu Sikeen Island 1
MUS-2	LCT-TARFFAH-1	Bu Sikeen Island	MUS-2 & Bu Sikeen Island 2
MUS-2	LCT-TARFFAH-1	Al Qatia Island	MUS-2 & Al Qatia Island 1
MUS-2	LCT-TARFFAH-1	Al Qatia Island	MUS-2 & Al Qatia Island 2
MUS-2	LCT-TARFFAH-1	Al Qatia Island	MUS-2 & Al Qatia Island 3
MUS-2	LCT-TARFFAH-1	Bu Sikeen Island	MUS-2 & Bu Sikeen Island 3
MUS-3	ADNOC-224	Umm Al Anbar	MUS-3 & Umm Al Anbar 1
MUS-3	ADNOC-224	Al Ghallan Island	MUS-3 & Al Ghallan Island 1
MUS-3	ADNOC-224	Ettouk Island	MUS-3 & Ettouk Island 1
MUS-3	ADNOC-224	Asseifiya Island	MUS-3 & Asseifiya Island 1
MUS-3	ADNOC-224	Umm Al Anbar	MUS-3 & Umm Al Anbar 2
MUS-4	ADNOC-225	Rig Mehzem	MUS-4 & Rig Mehzem 1
MUS-4	ADNOC-225	Rig SMS Essa	MUS-4 & Rig SMS Essa 1
MUS-4	ADNOC-225	Rig Yemillah	MUS-4 & Rig Yemillah!1
MUS-4	ADNOC-225	Umm Al Anbar	MUS-4 & Umm Al Anbar!1

 

[Peter_SSs]

Is this what you want then?

23 10 31.xlsm
	A	B	C	D
1	MUS No	Vessel Name	Location	Helper Column Join Formula Example
2	MUS-1	A-RANGER	Rig Mehzem	MUS-1 & Rig Mehzem 1
3	MUS-1	A-RANGER	Rig Al Noof	MUS-1 & Rig Al Noof 1
4	MUS-1	A-RANGER	Rig Mehzem	MUS-1 & Rig Mehzem 2
5	MUS-1	A-RANGER	Rig SMS Essa	MUS-1 & Rig SMS Essa 1
6	MUS-1	A-RANGER	Rig Yemillah	MUS-1 & Rig Yemillah 1
7	MUS-1	A-RANGER	Barge Lulwa	MUS-1 & Barge Lulwa 1
8	MUS-2	LCT-TARFFAH-1	Bu Sikeen Island	MUS-2 & Bu Sikeen Island 1
9	MUS-2	LCT-TARFFAH-1	Bu Sikeen Island	MUS-2 & Bu Sikeen Island 2
10	MUS-2	LCT-TARFFAH-1	Al Qatia Island	MUS-2 & Al Qatia Island 1
11	MUS-2	LCT-TARFFAH-1	Al Qatia Island	MUS-2 & Al Qatia Island 2
12	MUS-2	LCT-TARFFAH-1	Al Qatia Island	MUS-2 & Al Qatia Island 3
13	MUS-2	LCT-TARFFAH-1	Bu Sikeen Island	MUS-2 & Bu Sikeen Island 3
14	MUS-3	ADNOC-224	Umm Al Anbar	MUS-3 & Umm Al Anbar 1
15	MUS-3	ADNOC-224	Al Ghallan Island	MUS-3 & Al Ghallan Island 1
16	MUS-3	ADNOC-224	Ettouk Island	MUS-3 & Ettouk Island 1
17	MUS-3	ADNOC-224	Asseifiya Island	MUS-3 & Asseifiya Island 1
18	MUS-3	ADNOC-224	Umm Al Anbar	MUS-3 & Umm Al Anbar 2
19	MUS-4	ADNOC-225	Rig Mehzem	MUS-4 & Rig Mehzem 1
20	MUS-4	ADNOC-225	Rig SMS Essa	MUS-4 & Rig SMS Essa 1
21	MUS-4	ADNOC-225	Rig Yemillah	MUS-4 & Rig Yemillah 1
22	MUS-4	ADNOC-225	Umm Al Anbar	MUS-4 & Umm Al Anbar 1
Lukma

Cell Formulas
Range	Formula
D2:D22	D2	=A2&" & "&C2&" "&COUNTIFS(A$2:A2,A2,C$2:C2,C2)

 

[Lukma]

Is this what you want then?

Hi Peter_Sss

Really Great, just perfect as am really excited always to hear from you with the solution

So so Great many Thanks

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.