Results 1 to 3 of 3

Formula to extract a sub-set of dates from a larger set

Threaded View

  1. #1
    Registered User
    Join Date
    06-20-2014
    Location
    Newmilns,Scotland
    MS-Off Ver
    Windows Vista
    Posts
    1

    Formula to extract a sub-set of dates from a larger set

    I have a worksheet with a list of dates and events in range F2:G19. I want to use a formula to compare the month in cell A2, and the year in cell B2, and go through all the cells in range F2:F19 and extract each and all corresponding dates and place them in the range A5:A7. This is obviously a very simple matter using VBA, but I want to be able to use it on my Android phone, which will not run macros.

    Cross-posted at https://www.mrexcel.com/board/thread...r-set.1127567/
    Attached Files Attached Files
    Last edited by 6StringJazzer; 03-14-2020 at 03:26 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract Subarray from larger array with multiple criteria
    By owtu in forum Excel General
    Replies: 5
    Last Post: 10-10-2018, 01:57 PM
  2. [SOLVED] Excel formula to extract dates
    By mark888 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2016, 02:36 AM
  3. [SOLVED] Extract uniques and sort as a Smaller to larger
    By structo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-08-2016, 03:12 AM
  4. Replies: 5
    Last Post: 09-04-2016, 07:09 AM
  5. Count number of dates values in each cell and retain larger value only
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2016, 11:07 PM
  6. [SOLVED] take list of dates, and merge into larger table based on criteria
    By Rerock in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-15-2016, 03:25 PM
  7. [SOLVED] Dates are broken for use in a larger macro
    By Hyflex in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-05-2012, 06:27 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