+ Reply to Thread
Results 1 to 12 of 12

Changing Slope Calculation

Hybrid View

alecp Changing Slope Calculation 02-08-2012, 12:33 PM
Pete_UK Re: Changing Slope Calculation 02-08-2012, 01:16 PM
MrShorty Re: Changing Slope Calculation 02-08-2012, 01:20 PM
alecp Re: Changing Slope Calculation 02-08-2012, 01:48 PM
alecp Re: Changing Slope Calculation 02-08-2012, 01:58 PM
MrShorty Re: Changing Slope Calculation 02-08-2012, 02:44 PM
alecp Re: Changing Slope Calculation 02-08-2012, 02:51 PM
alecp Re: Changing Slope Calculation 02-08-2012, 03:00 PM
MrShorty Re: Changing Slope Calculation 02-08-2012, 06:21 PM
AndyPS Re: Changing Slope Calculation 02-08-2012, 07:02 PM
AndyPS Re: Changing Slope Calculation 02-08-2012, 09:44 PM
alecp Re: Changing Slope Calculation 02-09-2012, 10:31 AM
  1. #1
    Registered User
    Join Date
    06-29-2011
    Location
    South Carolina
    MS-Off Ver
    Excel 2003
    Posts
    20

    Re: Changing Slope Calculation

    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
    Last edited by alecp; 02-08-2012 at 04:50 PM. Reason: oops! reference off

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1