Results 1 to 11 of 11

Index Match only 4 results required

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2011
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    10

    Index Match only 4 results required

    Hi there.

    I have 2 lists of data - Column A = Names, Column B = Dates.
    The dates will always be the first of every month eg 01/08/2011 , 01/09/2011 etc.
    The results I need to display from these details are any 4 names matching the next month for example:

    Today's date is 29/07/2011 and the results I require would be those names matching 01/08/2011. However, if there are only 3 results, the fourth cell would remain blank, but if there are 6 results the formula can pick the first 4.

    I hope that makes sense.
    Thank you, in advance.
    Last edited by pepe.r.taylor; 08-01-2011 at 08:36 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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