OFFSET formula

[McM_]

Hello,

I am asking for a solution for the OFFSET formula, which will display the results as in column I. If the cell is written in D, take the information several rows (max 10 rows) down, until another information appears in column D and so on.
I used formula

Hello,

I am asking for a solution for the OFFSET formula, which will display the results as in column I. If the cell is written in D, take the information several rows (max 10 rows) down, until another information appears in column D and so on.

Thank you for help!

=OFFSET(D2;0;0)

Version Excel 365


Thank you for help!

 

[kevin9999]

One way...

Book1
	D	E	F	G	H	I
1
2	AAAA					AAAA
3						AAAA
4						AAAA
5						AAAA
6						AAAA
7						AAAA
8	BBBB					BBBB
9						BBBB
10						BBBB
11	CCCC					CCCC
12						CCCC
13						CCCC
14						CCCC
15						CCCC
16						CCCC
17						CCCC
18						CCCC
19						CCCC
20						CCCC
21						CCCC
22
Sheet1

Cell Formulas
Range	Formula
I2:I21	I2	=IF(D2<>"",D2,I1)

 

[arthurbr]

You will have to change the commas to semi colons in the solution provided in post #2
Also keep in mind that OFFSET is a volatile function and therefore to be used with caution

 

[kevin9999]

You will have to change the commas to semi colons in the solution provided in post #2

Well spotted @arthurbr

 

[arthurbr]

Well spotted @arthurbr

Thanks. I've made this "error" over and over in the other direction

 

[McM_]

Thanks for the answer, but I mention that I will not use column I. It was given as an example of how I want it to look at the end. I will only use D and H, and in D the frequency of filling the rows is random.
Do you have a solution?

 

[Alex Blakenburg]

So if you use @kevin9999's formula and modify it to look in column H and put it in H2 then copy it down, are you saying it doesn't give you the result you want ?

Copy this into H2 then copy it down to the end.

=IF(D2<>"",D2,H1)

 

[McM_]

Thank you Alex, it's works

 

[Alex Blakenburg]

Thanks for letting us know. It's @kevin9999's solution . Glad we could help.