How do I best get the LINEST and INTERCEPT formulas to ignore data that I have filtered out?
I have a table that has multiple data samples that meet each of my criteria for sorting, and I would like to see how the data trends change when I filter out some of the data points. Interestingly enough, I have noticed that the scatter graph that I have on the sheet updates itself with only the visible data, as does the trendline equation on the chart. I want that equation to update with my filterings on the sheet as well. Any help would be greatly appreciated.
Bookmarks