Results 1 to 3 of 3

Slope, IF, Multiple Data Points

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2016
    Posts
    2

    Slope, IF, Multiple Data Points

    I'm trying to compute the slope of various products that have variable pricing ad quantity sources. The actual file is well over 5k rows and the product skus are in no particular order. I would like to input a slope formula with an IF statement that calculates the slope of only products that match that SKU.

    I thought adding an IF statement into the array and saying IF the array within Column A has the item in Column A, select only that value.

    {=SLOPE(IF($A$8:$A$20=$A8,$C$8:$C$20,),IF($A$8:$A$20=$A8,$B$8:$B$20,))}

    I'm trying to calculate the information in the yellow Column of the attached file. I provided a check column and am seeing differences with my calculation.

    Any help is greatly appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 04-11-2017, 08:55 AM
  2. [SOLVED] Find The Slope of Three Points
    By artiststevens in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-31-2016, 07:43 AM
  3. Replies: 3
    Last Post: 01-23-2014, 03:19 PM
  4. Need macro to search multiple data points from multiple entries and return single value
    By Redbullmoo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2013, 02:16 AM
  5. Calculating Slope and Intercept with a changing number of data points
    By WE5T in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2013, 05:48 AM
  6. Compare multiple data points in row _ multiple sheets _ output different information
    By floydian in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2013, 08:52 AM
  7. slope of a set of points
    By jcody in forum Excel General
    Replies: 3
    Last Post: 09-20-2012, 10:10 AM

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