Dynamic Trend Regression Formula?

[nobodyukno]

Ok so heres an example workbook:

Book5.xlsx

As you can see from the workbook, each column's amount of numbers depends on the data pulled from an index/match function.

These numbers will change and I want the TREND function to dynamically change with the data.

Any ideas?

[nobodyukno]

Any ideas?

[nobodyukno]

Its not even really the regression part but more about the dynamic ability

[nobodyukno]

Any ideas about dynamic?

[shg]

At a glance, I don't have a clue what you're trying to do, or why a circular reference is required, but the formula in B2 (whatever it does) could be simplified to

=IFERROR(INDEX($H$5:$H$202,MATCH(B$3,IF($S$5:$S$202=$BH2,$B$5:$B$202),0)), "")