Results 1 to 25 of 25

Conditional Slope

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2010
    Location
    Abu Dhabi, UAE
    MS-Off Ver
    Excel 2003, 2007 and 2010
    Posts
    148

    Thumbs up Conditional Slope

    Hi,

    I have data of numbers in columns A and B from A21 to A30, and B2 to B30,

    I'm looking for a function that can help me to get slopes out of A and B data (data on column A as X axis, and Y on the B), the idea is that if I type a letter (like "O" ) anywhaere in the column C like in cells C2,C3, C5, C7, for example then in the cell (D2) I get the slope of the points: (A2,B2) , (A3,B3) , (A5,B5) and (A7,B7)... and if I type at the same time "W" anywhaere in different cells
    on the column C I get the slope of those points in the cell D4...
    I attched an example to clarify the idea...

    Appreciate help!
    Attached Files Attached Files
    Last edited by Ralem; 05-19-2010 at 04:51 PM.
    Cheers
    Ralem

Thread Information

Users Browsing this Thread

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

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