+ Reply to Thread
Results 1 to 2 of 2

Task search as per date range and a name

  1. #1
    Registered User
    Join Date
    05-15-2019
    Location
    India
    MS-Off Ver
    2019
    Posts
    1

    Task search as per date range and a name

    Hi, I have a table and want to extract data using two conditions date range and name:

    Table.png



    without date range, i have used :
    =TEXTJOIN(CHAR(10),TRUE,IF(M52:M55=I70,(J52:J55),""))

    but how to use it with date range as well.

    Thanks in advance

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,193

    Re: Task search as per date range and a name

    Try something like this - array entered, probably (I don't have TEXTJOIN (XL2016 for me) so I am guessing a bit....)

    =TEXTJOIN(CHAR(10),TRUE,IF($M$52:$M$55=$I70,IF($K$52:$K$55<=J$69,IF($L$52:$L$55>=J$69,$J$52:$J$55))),""))
    Bernie Deitrick
    Excel MVP 2000-2010

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Does a task start or finish date fall within 3 month range of a specific date
    By jamesmcgallan in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-19-2015, 07:46 AM
  2. Search large date range with narrow filetered range
    By druth in forum Excel General
    Replies: 14
    Last Post: 08-02-2014, 09:01 AM
  3. Search date range +/- 7 days and return date that falls within range
    By tlafferty in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2013, 03:26 PM
  4. Replies: 6
    Last Post: 01-27-2013, 07:39 PM
  5. Replies: 0
    Last Post: 01-17-2013, 06:51 AM
  6. Replies: 0
    Last Post: 07-24-2012, 05:49 PM
  7. Count Unique Task IDs Completed within a Date Range
    By Spoklahoma in forum Excel General
    Replies: 6
    Last Post: 12-11-2011, 01:50 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