LINEST - exclude x variables and empty rows

Hi, all

I'm trying to populate a regression model here for multiple parameters here hence, I believe VBA can make my life easier.

1. Is it possible if the VBA to exclude the x variable(s) for LINEST() formula in cell range J3:M3 if the column(s) is/are empty?
2. Is it possible if the VBA to eliminate empty rows or rows with "BAD" data?
3. Is it possible if the VBA can populate the formula to each cell in column G (model) which has good data in instead of having the formula in every cell of the column?

Hereby I attached my Excel file. Hope anyone can enlighten me. Thank you so much!

Hi, anyone can help me with this?

Thanks in advance!

Hi, Glenn

I was told that the more data I have, the more accurate the regression would be, and just to give an idea to all how much data would this VBA need to manage. Hence I gave an example of this much of data. There are blank rows at row 7066 as an example, and "BAD" data is rows that's showing "BAD".

Thanks.

Hi, Glenn

If that's the case then, would gladly change. Here's the new attachment.

Thanks.

Hi, Glenn

Unfortunately "BAD" data can happen anywhere in the known x's hence, could not use your formula but thanks.

Anyone can give me a hand in this?

Hi, all

A little update:
I manage to solve number 2 and 3 of my problems.

For the case of number 1, I believe using formula and functions might be able to be used hence, I would post there instead and mark this as solved. Thanks.