Results 1 to 8 of 8

formula that searches an array

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-05-2013
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    Excel for Mac 2024
    Posts
    142

    formula that searches an array

    On the morning of the Ex-Dividend Date, dividend stocks typically fall from the price the day before the Ex-dividend date by the amount of the declared dividend. The stock price then recovers back to the price (equals or exceeds) on the day before the Ex-Dividend Date, where that may take a day or many days but typically only a few days.

    I need a formula that reviews a table of historical prices and supplies (in cells T5 and T6 inside the Thick Box Borders) the number of days it takes for the price to recover. I need for the formula to also supply that number from a specific ticker symbol, where the prices are organized by ticker symbol.

    The formula I have (in cell T5) uses AGGREGATE, INDEX, MATCH, and ROW. It performs the first part (Days To Recover) but not the second part (specific to a Ticker), and thus does not work for a large table with many prices for many different Tickers.

    See workbook attached.

    I need help fixing that formula.

    Thanks for your help!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. need a formula that searches football results but only last 6
    By jono121ukk in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-11-2016, 03:24 PM
  2. formula that returns value from the same row it searches
    By Bill Ratliff in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-27-2014, 03:33 PM
  3. [SOLVED] Other was to do more then 6 searches in one formula
    By Shannon561 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-02-2014, 07:43 PM
  4. [SOLVED] =IF formula that searches text
    By financegrl in forum Excel General
    Replies: 8
    Last Post: 09-20-2012, 08:11 PM
  5. The application searches for the smallest value in the array
    By jacek890 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2012, 05:22 PM
  6. Getting valid web searches and avoiding sites that contaminate web searches
    By David McRitchie in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-12-2006, 10:10 PM
  7. [SOLVED] FIND formula that searches from right?
    By KellyB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-21-2005, 07:06 PM

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