filling down multiple cells

[excelNewbie22]

hi !
long time....

i want to fill down a column (long one) with multiple different dates,
each date to be feel down just till the next one
and if possible in a smaller font, and unbolded
i added an example

temp
	A	B	C
2	before		after
3
4	1.1.24		1.1.24
5			1.1.24
6			1.1.24
7			1.1.24
8			1.1.24
9	15.1.24		15.1.24
10			15.1.24
11			15.1.24
12			15.1.24
13	23.1.24		23.1.24
14			23.1.24
15			23.1.24
16			23.1.24
17	29.1.24		29.1.24
18			29.1.24
19			29.1.24
20			29.1.24
21	2.2.24		2.2.24
22			2.2.24
23			2.2.24
24			2.2.24
25			2.2.24
26			2.2.24
27			2.2.24
28			2.2.24
29			2.2.24
30			2.2.24
31	10.2.4		10.2.4
32			10.2.4
33			10.2.4
34			10.2.4
35			10.2.4
sheet1

 

[Joe4]

Take a look here, which shows you manual, VBA, and Power Query solutions to this:

3 Ways to Fill Down Blank Cells in Excel - Excel Campus

If you have blank cells in your data and you want to copy down the values above them, fill down using a macro, formula, or Power Query.

www.excelcampus.com

 

[excelNewbie22]

thanks joe!
used the first method, the formula one

 

[Joe4]

You are welcome!
Yep, it is a cool little trick that is pretty easy to do (when you know how!)

 

[Cubist]

Here's a dynamic array option.

Book1
	A	B	C
1	before		after
2
3	1.1.24		1.1.24
4			1.1.24
5			1.1.24
6			1.1.24
7			1.1.24
8	15.1.24		15.1.24
9			15.1.24
10			15.1.24
11			15.1.24
12	23.1.24		23.1.24
13			23.1.24
14			23.1.24
15			23.1.24
16	29.1.24		29.1.24
17			29.1.24
18			29.1.24
19			29.1.24
20	2.2.24		2.2.24
21			2.2.24
22			2.2.24
23			2.2.24
24			2.2.24
25			2.2.24
26			2.2.24
27			2.2.24
28			2.2.24
29			2.2.24
30	10.2.4		10.2.4
Sheet2

Cell Formulas
Range	Formula
C3:C30	C3	=SCAN(,A3:A30,LAMBDA(a,b,IF(b="",a,b)))
Dynamic array formulas.

 

[Peter_SSs]

each date to be feel down just till the next one

What happens to the last one? That is, in your example if 10.2.4 was the last value in column A how would we know to fill it down to row 35 and not just to row 33 or to row 100?