Menu
Basically, the problem is summarized by the picture below.
https://imgur.com/a/vBU2xMK
The "Start" column is when the beginning of "Descriptor" variable starts and it populates the number of rows starting according to the value in the "Length" column that starts from the "Start" column.
Solving this using values is simple on a small dataset such as the example but how would it be replicated using formula?
Thanks,
429
Anyone who has used Excel for some time knows how to use the autofill feature to autofill an Excel cell based on another. You simply click and hold your mouse in the lower right corner of the cell, and drag it down to apply the formula in that cell to every cell beneath it (similar to copying formulas in Excel).
Dynamic Formulas allow you to insert Excel's formulas into cells even when the formula must reference rows that will be inserted later during the merge process. They can repeat for each inserted row or use only the cell where the field is placed.
Something like this in cell D2, then drag as needed.
=IF(AND(COLUMN()-3>=$A2,COLUMN()-3<$A2+$B2),$C2,"")
just noticed the numbers up top, so this is also workable:
=IF(AND(D$1>=$A2,D$1<$A2+$B2),$C2,"")
@Bryan60 his answer is nice and clear!
For the sake of alternatives, in cellD2:
=IF(D$1=MEDIAN(D$1,$A2,$A2+($B2-1)),$C2,"")
Or when the numbers on the top are not there:
=IF(COLUMN(A1)=MEDIAN(COLUMN(A1),$A2,$A2+($B2-1)),$C2,"")
Drag down and right.
2
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
