Intercept and Slope of visible rows, please.

Joined
Jul 25, 2014
Messages
2
Reaction score
0
Hi,

I cant seem to get my head around the subtotal function people use to achieve this.

My X-axis values is from H2:H1642 and the Y-axis is J2:J1642. I want to calculate the slope and intercept of this data, AFTER I applied a filter to these rows...

Could someone please help me...

Regards,
B
 
Back
Top