Replicate inconsistent values in col A to Col B

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have one column of data. Lets say the value in A1 is 100 and there are no values again until A10 where the value is 200. I need a formula that I can put in every cell in column B that will return the value that is in A1 until that value changes in A10 and then starts putting that value in column B until it gets to the next different value in column A.

Thanks.
 
Hi Giles
try the following:
in B1 enter
=A1
in B2 enter:
IF(A2="",B1,A2)
and copy down

Frank
 
Back
Top