I am trying to get a formula to work. How do i reference a change in cells. As you can see i am copying the range on the left. when there is a change in the headings (A1,A3, A5) etc i would like to to show in N2, N4, N6 ETC. The blank rows on the right are rows i have deleted. I hope i have explained this well.