I've read a few dozen posts on linking trendlines to cells, but none of them seem to offer a solution to my problem so far.
The trendline equation on the chart automatically updates to reflect what data in a table is visible (not filtered out). All of the formula equations I've seen use the full dataset with no regard for filtering.
I only need M and B extracted. I have a macro that copy/pastes the formula into a cell, so my first thought is a macro/formula that filters out all the characters around M and B. Any recommendations?
V/R
Mike
The trendline equation on the chart automatically updates to reflect what data in a table is visible (not filtered out). All of the formula equations I've seen use the full dataset with no regard for filtering.
I only need M and B extracted. I have a macro that copy/pastes the formula into a cell, so my first thought is a macro/formula that filters out all the characters around M and B. Any recommendations?
V/R
Mike