+ Reply to Thread
Results 1 to 2 of 2

Complicated Percentage Formula?

  1. #1
    Registered User
    Join Date
    02-02-2011
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2010
    Posts
    1

    Talking Complicated Percentage Formula?

    Alright, I'm completely stuck here.

    I'm looking to create a formula to find a minimum 20% increase in a set of DJI data over time. I have the data laid out so that the date is in column A, closing price is in column B, and percentage change from the day before in column C.

    I need to know every pair of dates that yield this 20% increase, keeping in mind that after a set of dates has been used it cannot be used again. (As an example, say January 12th 1982 to March 3rd 1983 had a 20% increase. I wouldn't want to know that August 14th 1982 to June 22nd 1983 also had that increase.)

    Anyone have a clue how to do this? I know it'll be extremely complicated so any help is much appreciated.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Complicated Percentage Formula?

    A sample data set would help - along with some expected results - dummy any values that you deem confidential but ensure the data types used remain (ie if changing text ensure you replace with text [not number])

+ Reply to Thread

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