For each chance in column A, copy column B and fill down in column C

[Angus_12]

Hi All,

I'm looking for a for a macro or formula that recognises a change in Column A, then at each change, it copies the same row from column B, pastes the value to column C and fills the next months downs until the next change in column A. At the moment I have Column A and B however I want it to create column C for me...??

[TABLE="width: 50"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1112[/TD]
[TD]OCT[/TD]
[TD]OCT[/TD]
[/TR]
[TR]
[TD]1112[/TD]
[TD]OCT[/TD]
[TD]NOV
[/TD]
[/TR]
[TR]
[TD]1112[/TD]
[TD]OCT[/TD]
[TD]DEC[/TD]
[/TR]
[TR]
[TD]1113[/TD]
[TD]FEB[/TD]
[TD]FEB[/TD]
[/TR]
[TR]
[TD]1113[/TD]
[TD]FEB[/TD]
[TD]MAR[/TD]
[/TR]
[TR]
[TD]1114[/TD]
[TD]AUG[/TD]
[TD]AUG[/TD]
[/TR]
[TR]
[TD]1115[/TD]
[TD]MAR[/TD]
[TD]MAR[/TD]
[/TR]
[TR]
[TD]1115[/TD]
[TD]MAR[/TD]
[TD]APR[/TD]
[/TR]
[TR]
[TD]1115[/TD]
[TD]MAR[/TD]
[TD]MAY[/TD]
[/TR]
[TR]
[TD]1115[/TD]
[TD]MAR[/TD]
[TD]JUN[/TD]
[/TR]
[TR]
[TD]1116[/TD]
[TD]SEP[/TD]
[TD]SEP[/TD]
[/TR]
[TR]
[TD]1116[/TD]
[TD]SEP[/TD]
[TD]OCT[/TD]
[/TR]
[TR]
[TD]1116[/TD]
[TD]SEP[/TD]
[TD]NOV[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


thankyou in Advance.

 

[CyrusTheVirus]

Welcome to the forums. Try the below, but it assumes your data starts in Row 2.

C2:

=UPPER(IF(ROWS($B$2:B2)=1,B2,IF(B2<>B1,B2,TEXT(DATE(2019,MONTH(1&C1)+1,1),"mmm"))))

 

[jtakw]

Hi,

Assuming your Column B months are Text:

Book1
	A	B	C
1	1112	OCT	OCT
2	1112	OCT	NOV
3	1112	OCT	DEC
4	1113	FEB	FEB
5	1113	FEB	MAR
6	1114	AUG	AUG
7	1115	MAR	MAR
8	1115	MAR	APR
9	1115	MAR	MAY
10	1115	MAR	JUN
11	1116	SEP	SEP
12	1116	SEP	OCT
13	1116	SEP	NOV
Sheet610

Cell Formulas
Range	Formula
C1	=UPPER(IF(COUNTIF(A$1:A1,A1)=1,B1,TEXT(EOMONTH((B1&1),COUNTIF(A$1:A1,A1)-1),"mmm")))

C1 formula copied down.

 

[Angus_12]

Thank you both for posting this, it has worked perfectly!

greatly appreciated.

Regards.

 

[CyrusTheVirus]

Cool. You're welcome.

 

[jtakw]

You're welcome, welcome to the forum, and thanks for the feedback.