+ Reply to Thread
Results 1 to 15 of 15

Return oldest date in range using asterisk as criteria

Hybrid View

glomb175 Return oldest date in range... 06-01-2018, 02:23 PM
JohnTopley Re: Return oldest date in... 06-01-2018, 02:29 PM
63falcondude Re: Return oldest date in... 06-01-2018, 02:29 PM
glomb175 Re: Return oldest date in... 06-01-2018, 02:36 PM
63falcondude Re: Return oldest date in... 06-01-2018, 02:31 PM
63falcondude Re: Return oldest date in... 06-01-2018, 02:42 PM
glomb175 Re: Return oldest date in... 06-01-2018, 02:44 PM
63falcondude Re: Return oldest date in... 06-01-2018, 02:48 PM
glomb175 Re: Return oldest date in... 06-01-2018, 02:56 PM
63falcondude Re: Return oldest date in... 06-01-2018, 03:01 PM
glomb175 Re: Return oldest date in... 06-01-2018, 03:05 PM
JohnTopley Re: Return oldest date in... 06-01-2018, 03:16 PM
63falcondude Re: Return oldest date in... 06-01-2018, 03:24 PM
glomb175 Re: Return oldest date in... 06-01-2018, 03:37 PM
JohnTopley Re: Return oldest date in... 06-01-2018, 03:54 PM
  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    Newbury
    MS-Off Ver
    2010
    Posts
    50

    Re: Return oldest date in range using asterisk as criteria

    Thank you, I've updated the attached so that the Kitchen department contains multiple sub departments each beginning with a different letter.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,684

    Re: Return oldest date in range using asterisk as criteria

    How do you link Kitchen (parent) to Children ??????

    EDIT: did not see Sheet3!!!!
    Last edited by JohnTopley; 06-01-2018 at 03:29 PM.

+ 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. [SOLVED] Return the oldest date when cell does not contain an *(Asterix)
    By C J W in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2017, 12:25 PM
  2. Return oldest date in range when a file is open
    By mementomori in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-08-2016, 10:17 AM
  3. Return oldest date with some dates excluded
    By Stromming in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2014, 06:32 AM
  4. return oldest date based on call value
    By 288enzo in forum Excel General
    Replies: 8
    Last Post: 02-28-2014, 10:50 PM
  5. [SOLVED] Find Oldest Date for Criteria in different Column
    By mglassco in forum Excel General
    Replies: 12
    Last Post: 04-19-2012, 09:27 PM
  6. Display value based on oldest date and other criteria.
    By Permagrin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2009, 09:48 AM
  7. Getting the oldest date with criteria
    By Sara_Chase in forum Excel General
    Replies: 5
    Last Post: 10-17-2006, 08:11 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