Results 1 to 15 of 15

Return oldest date in range using asterisk as criteria

Threaded View

  1. #1
    Registered User
    Join Date
    06-02-2017
    Location
    Newbury
    MS-Off Ver
    2010
    Posts
    50

    Return oldest date in range using asterisk as criteria

    I'm having trouble with my formula in Sheet1!C:C which I believe is due to the fact that I'm using an asterisk as part of the search criteria. I previously used specific criteria e.g. "Kitchen" however due to multiple departments falling under the parent departments (detailed on Sheet3), I need the formula to look for any data beginning with a K. This method worked in Sheet1!B:B using a COUNTIF function, however it doesn't seem to work in my array.
    Attached Files Attached Files

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