Linest

[gary2312]

Hi there,

I've got a LINEST function working on some data, however each month new data is added.

Is there anyway to get this function to look at the new data automatically? I'ev tried blank cells, #n/a#s and putting zeros in cells but the function doesn't like these. I was thinking a pivot table that updates somehow might work but I may be completely off target with that idea.

Thanks

 

[gary2312]

I know this is really cheeky, but I also need to explain how I've managed to get the parameters out in a report im writing.

Is there any chance u could give a brief explanation of how the various parts work? Like the INDEX, MATCH and LROW parts.

If not don't worry, i'll try looking it up somewhere.

Thanks again for all your help.