Moving cells by adding rows.

[kramart]

2017-07

2017-06

2017-07

2017-07

<colgroup><col style="mso-width-source:userset;mso-width-alt:1974;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:4315;width:89pt" width="118"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="width: 54"]2017-06
[/TD]
[TD="class: xl65, width: 118, align: center"]AAA
[/TD]
[TD="width: 64, align: right"]163386[/TD]

[TD="class: xl65, align: center"]AAA
[/TD]
[TD="align: right"]12807
[/TD]

[TD="class: xl65, align: center"]BBB
[/TD]
[TD="align: right"]31531[/TD]

[TD="class: xl65, align: center"]BBB[/TD]
[TD="align: right"]16388[/TD]

[TD="class: xl65, align: center"]CCC
[/TD]
[TD="align: right"]114734[/TD]

</tbody>

This is my data. The first column is date then client code and finally value. Every month the data is amended by adding extra rows for a new month, so it looks like this.

2017-07
2017-08
2017-06
2017-07
2017-08
2017-07
2017-08

<colgroup><col style="mso-width-source:userset;mso-width-alt:1974;width:41pt" width="54"> <col style="mso-width-source:userset;mso-width-alt:4315;width:89pt" width="118"> <col style="width:48pt" width="64"> </colgroup><tbody>
[TD="width: 54"]2017-06[/TD]
[TD="class: xl65, width: 118, align: center"]AAA
[/TD]
[TD="width: 64, align: right"]163386[/TD]

[TD="class: xl65, align: center"]AAA[/TD]
[TD="align: right"]12807
[/TD]

[TD="class: xl65, align: center"]AAA[/TD]
[TD="align: right"]555444
[/TD]

[TD="class: xl65, align: center"]BBB[/TD]
[TD="align: right"]31531[/TD]

[TD="class: xl65, align: center"]BBB[/TD]
[TD="align: right"]16388
[/TD]

[TD="class: xl65, align: center"]BBB[/TD]
[TD="align: right"]222333[/TD]

[TD="class: xl65, align: center"]CCC[/TD]
[TD="align: right"]114734[/TD]

[TD="class: xl65, align: center"]CCC[/TD]
[TD="align: right"]111555
[/TD]

</tbody>

I need a formula that would get values for given months. For example, if the value for the client AAA for 2017-07 is 12807 (cell C2) then after adding a row for 2017-08 the formula would get the value 555444 (cell C3) and next month would go to cell C4 and so on. For other clients, the same scenario.


Cheers,

A

 

[arthurbr]

Supposing you want results in col D (?) =IF($B1<>$B2,$C1,"") and pull down as needed

 

[kramart]

Thanks! Simple and effective.

 

[kramart]

However I want to use the formula on a separate sheet for each client for a period of 12 months so if I use this formula the fourth month / cell will show the value from another client. Is there a way to make sure that values are from the required client?