Update Array Formulas automatically

[LordByron]

Hi All!

I have a replica sheet here which contains an array formula. In my original sheet it has over 20 array formulas which I have to update constantly with new rows of data.

The array formula is simply {=trend(data:data)}

I would be grateful if someone could tell me if it is possible & how to make this type of array formula update automatically when new data is added and to make the calculation automatic - either using an alterative formula or VBA.

Thanks in advance!

[Bo_Ry]

Please try at D3
=IF(C3="","",INDEX(TREND(C$3:INDEX(C:C,MATCH(9,C:C))),ROWS(D$3:D3)))

[LordByron]

Please try at D3
=IF(C3="","",INDEX(TREND(C$3:INDEX(C:C,MATCH(9,C:C))),ROWS(D$3:D3)))

This is excellent! Thank you so much for your help! I really appreciate it!

Just one point for my clarification, the sheet is attached; it is returning a #Ref while all other formulas are working - would you be able to assist me on this? Thanks!

[Bo_Ry]

Change C2 to this

=IF(B2="","",INDEX(TREND(B$2:INDEX(B:B,MATCH(9^9,B:B))),ROWS(A$2:A2)))

[LordByron]

Change C2 to this

=IF(B2="","",INDEX(TREND(B$2:INDEX(B:B,MATCH(9^9,B:B))),ROWS(A$2:A2)))

Great! Youre a legend! Thank you so much for your help - I am most grateful!

[protonLeah]

Named DYNAMIC range: PriceByDate
Refer to:

Please Login or Register  to view this content.

formula for clumn C:

Please Login or Register  to view this content.