Personally, the advice is, don't use merged cells.

I would split them and then use Conditional Formatting to "hide" duplicated entries.

Split all the cells (model and year). Repeat the model and year in cells A4 and B4. Select cells A2 down to B4. Then select Conditional Formatting. Choose New Rule and "Use a formula ...". The formula is: =A2=A1 (no absolutes) and, in the formatting, choose the same sickly green you have used as the fill colour.

That should hide any duplicated values.


Regards, TMS