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...??

A	B	C
1112	OCT	OCT
1112	OCT	NOV
1112	OCT	DEC
1113	FEB	FEB
1113	FEB	MAR
1114	AUG	AUG
1115	MAR	MAR
1115	MAR	APR
1115	MAR	MAY
1115	MAR	JUN
1116	SEP	SEP
1116	SEP	OCT
1116	SEP	NOV

<tbody>
</tbody>

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.