SLOPE formula help!

ive tweaked the formula slightly to get the Min/Max to encompass the range to determine the X,Y for your Slope

For instance
E-09
your slope formula should be Slope(B56:B196,A56:A196) right?
whereby row 56 is your start and the 196 is your finish?

if so then CSE formula again

Formula:

Please Login or Register  to view this content.

ive included the results of min/max seperately so you can verify and check results are as expected

on the conditional format bit then
i just used a simple formula for cell with Slope>0

i am very unfamiliar with whatever you are actually doing
so not quite sure what the "desired" is in column G

what i gave you previously was the representative ROW of the time frame range
so for E-09
14:48:12 starts at Row 56
14:48:42 ends at Row 196
to get the maximum VALUE of this range it would be max(B56:B196) right?

if so then the formula would be

Formula:

Please Login or Register  to view this content.

...
min value would be

Formula:

Please Login or Register  to view this content.

both CSE formula as per usual

updated file with these two formulas showing now attached

If I may interject a few thoughts:

Why are the values in G14:G18 correct? They appear to be based on the slopes computed from the chart trendlines, but are these correct? In order to understand and interpret the chart trendline, one needs to note that:
1) your chart is a line chart type.
2) Because all of the "x" data is on the same day, a date axis has no meaning, so Excel chooses a text/category axis.
3) which means that the x values going into the chart trendline are count numbers (1,2,3,4,...) rather than the actual time values.
With that explained, one could interpret the chart slope as "change in units per entry". Your entries are not equally spaced in time. A quick look suggests that you are recording data approximately every 200 to 250 ms, so one could possibly interpret the slope as "change in units per 200 to 250 ms", but that is not a very precise slope.

Looking at the humdingaling's slope function, it is using the actual date/time serial numbers for the regression. Assuming you are familiar with Excel's date/time serial number system, you will recall that 1 unit on this system is 1 day, so the -202.9... slope from his formula can be interpreted as "change in units per day". Doing the unit conversion to "change in units per 225 ms" (-203/24(hours/day)/60(min/hour)/60(sec/min)/0.225(sec/sec)) results in a slope of -0.000529 "change in units per 225 ms", which is close to the value from the chart trendline.

At this point, it is my opinion (which is probably worth what you paid) that humdingaling's formula is technically more correct/accurate than the chart trendline (assuming that you are trying to recreate the chart trendline calculation). Recognizing that his result is "units per day", you can express the slope/rate in whatever units you want by performing an appropriate unit conversion.

If you really decide that the chart trendline calculation is the more correct, then substitute an array of count numbers for the "known_x" argument in humdingaling's SLOPE() formula.