Results 1 to 6 of 6

change formula to extract data from between two dates

Threaded View

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    change formula to extract data from between two dates

    I have a workbook that monitors duel fuel vehicles for cost analysis. At present the output screen draws all of the entries specific to the chosen vehicle number from the entered data worksheet. I have a section that sums the values of the data for entries between two chosen dates. I would like the output screen to only display the entries corresponding to the two dates in use to pre-empt the problems encountered as the entries grow.

    The formula in question are in cells starting from b3,c3,d3,e3,f3,g3. The chosen dates are displayed in n1 and p1.

    {=IFERROR(INDEX('ENTERED DATA'!$B$2:$H$1289,SMALL(IF(INDEX(('ENTERED DATA'!$A$2:$A$1289=$C$1)*('ENTERED DATA'!$C$2:$C$1289=$M$5),0),(ROW('ENTERED DATA'!$A$2:$A$1289)-1),""),ROW(1:1)),COLUMN(A:A)),"")}
    they are array formulas. Any help appreciated.

    test file attached
    Attached Files Attached Files
    Last edited by nigelog; 09-28-2015 at 04:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Extract data between two dates to listbox
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2015, 07:07 PM
  2. Extract data between two dates
    By Ogi in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-24-2014, 07:19 AM
  3. Formula to change chart data source for all dates up to today
    By jhalsall80 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-12-2014, 01:34 PM
  4. Extract unique dates from a list through formula only
    By maniknandi in forum Excel General
    Replies: 7
    Last Post: 07-29-2013, 02:48 AM
  5. Array formula to extract information in-between two dates
    By Kayees in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-25-2013, 05:00 AM
  6. Extract data between two dates
    By grey_hair in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-21-2011, 10:25 AM

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