Fill down two columns based on previous value until new value occurs

Hi there,

I would to have a quicker way of filling down two columns with values based on previous cell value.

Please see the attached.

In the worksheet1, you see number 3, 6 under col A and "AA" and "BB" under col F.

What I want:

I want to have excel automatically fill down both 2 columns with specified values. So, if row 3 to row 8 are all under 3 in col A, then I want A3 to A8 = 3, so A10 to A 21 = 6, etc.

Col F is the same thing.

Because the list is rather big, I don't want to manually type them in... only need to fill down on col A and F..

Any ideas?

Thanks very much

Add a helper column between A & B and add this formula...

=IF(A2="",B1,A2)

copy this down ad far as yuou need. also copy the same formula to (the new) H column. This should give you what you need, you can hide thes columns if needed

Glad to help, please mark this as solved