Results 1 to 21 of 21

Finding values between between two specific entries (between two dates)

Threaded View

  1. #1
    Registered User
    Join Date
    12-03-2017
    Location
    Bangladesh
    MS-Off Ver
    2016
    Posts
    23

    Finding values between between two specific entries (between two dates)

    Hi everyone!

    I sought help at MrExcel a couple of days ago about this but not getting any response.
    HTML Code: 
    The worksheet attached below:
    HTML Code:
    https://www.dropbox.com/s/2vt49l368f...est1.xlsx?dl=0

    I have some data in range B8:H15. Column B is formatted as 'Date'. Some durations are located at D8:H15 in [h]:mm format.

    At K3 and K4 I have two dates. K3 is the Start Day and K4 the End Day between which I am trying to calculate. At K5 I have found out the number of entries between these two dates using the following formula.
    Code:
    =COUNTIFS($B$8:$B$18,">="&K3,$B$8:$B$18,"<="&K4)
    The formula returns "4" entries between these two dates as it should.

    In range M8:S15 I am trying to list out the entries between those two specific days only. I have used the following formula at M8:
    Code:
    =IFERROR(INDEX(B$8:B$18,SMALL(IF($B$8:$B$18>=$K$3,IF($B$8:$B$18<=$K$4,ROW($B$8:$B$18)-ROW($B$8)+1)),ROWS(K$3:K3))),"")
    Then using the fill handle I have copied the formula to the whole destination range M8:S15. So the destination range has now 4 entry rows as it should given the Start and End date range.

    WHAT I NEED NOW

    I need a way so that I am able to select specific entries between those two dates. What I mean by that is, if there are multiple entries on the same day (2 and 5 Jan in the worksheet attached above), I need a way to be able to list out the entries starting at 2nd entry of 2 Jan up to 2nd entry of 5 Jan. I want the Start Day (K3) and End Day(K4) to offer me options so I could pick the entry I like if there are multiple entries on the same day.

    Is that even possible?

    Can anyone please help? Thanks in advance!
    Last edited by Masud8956; 09-10-2018 at 08:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Rank entries based on values and dates
    By sebroa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2017, 03:07 PM
  2. [SOLVED] How do I return specific values from table with multiple entries
    By BigSpeekaz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2014, 03:31 PM
  3. Grouping entries by quarter & specific dates ?
    By andyzz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-30-2014, 12:03 AM
  4. Finding difference in dates for repeat entries
    By strikinglyfamiliar in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-27-2012, 03:21 PM
  5. Finding a date in a specific column surounded by other columns with similar dates
    By Freakazoid in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-21-2012, 05:28 AM
  6. Finding values between entries in Hlookup
    By Bob Pritchard in forum Excel General
    Replies: 4
    Last Post: 01-11-2012, 01:47 PM
  7. counting unique entries for a specific date period in a series of dates
    By woody382 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-16-2010, 01:57 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