Changing Slope Calculation

**MrShorty** · 02-08-2012, 02:44 PM

How about the SLOPE() function?

**alecp** · 02-08-2012, 02:51 PM

I tried it, but I couldnt get the ranges to reference correctly with the other sheet and idk why. I tried a function but I accidentally deleted it...it had a =slope(address(match(time1)):address(match(time2))) type thing in there, with obviously more stuff in each of the functions...but I guess what I don't understand is how to use the address function with the array that slope wants...i.e. =slope(E4:E50,D4:D50) would work...but does =slope(address():address(), address():address()) work? That may be a newbie way to do it, but I was hoping it would work...maybe I just typed it in incorrectly. I'll build it back to what I had in the meantime

I hope that made sense...

**alecp** · 02-08-2012, 03:00 PM

Okay I went back to what I tried for the test sheet that I uploaded and my formula went something like this...

=SLOPE(ADDRESS(MATCH('Calculation Sheet'!$B$5,'Data to be referenced in sheet'!C:C,1),3,1,1,"'Data to be referenced in sheet'!"):ADDRESS(MATCH('Calculation Sheet'!$C$5,'Data to be referenced in sheet'!C:C,1),3,1,1,"'Data to be referenced in sheet'!"),ADDRESS(MATCH('Calculation Sheet'!$B$5,'Data to be referenced in sheet'!C:C,1),4,1,1,"'Data to be referenced in sheet'!"):ADDRESS(MATCH('Calculation Sheet'!$C$5,'Data to be referenced in sheet'!C:C,1),4,1,1,"'Data to be referenced in sheet'!"))

I guess you can't do slope(address():address(),address():address()). Idk I'm relatively new to this whole reference function game