+ Reply to Thread
Results 1 to 2 of 2

Using MATCH-INDEX to list occuring dates of values in a data table

  1. #1
    Registered User
    Join Date
    12-31-2008
    Location
    Alaska, (not Anchorage)
    MS-Off Ver
    Excel 2010, 2016, and 365
    Posts
    78

    Using MATCH-INDEX to list occuring dates of values in a data table

    I'm parsing a large table into a report and could use some help. In a two page Excel workbook I have the following tabs:

    "~data tab~"
    date | type
    6/21/2011 | Blue Volvo
    6/21/2011 | Red Citroen
    6/23/2011 | Yellow Mazda
    6/23/2011 | Green Ford
    6/23/2011 | Silver Toyota
    6/23/2011 | White Landcruiser
    6/28/2011 | Blue Volvo
    6/28/2011 | Red Citroen
    6/28/2011 | Yellow Mazda
    6/28/2011 | Green Ford
    7/2/2011 | White Landcruiser
    7/2/2011 | Silver Toyota
    7/2/2011 | Green Ford
    7/2/2011 | Yellow Mazda
    7/3/2011 | White Landcruiser
    7/3/2011 | Blue Volvo
    7/12/2011 | White Landcruiser
    7/30/2011 | Red Citroen

    "~report tab~"
    type | date
    White Landcruiser | 6/23/2011
    <blank> | 7/2/2011
    <blank> | 7/3/2011
    <blank> | 7/12/2011
    <blank> | <blank>
    <blank> | <blank>
    <blank> | <blank>
    <blank> | <blank>
    <blank> | <blank>
    <blank> | <blank>
    Green Ford | 6/23/2011
    <blank> | 6/28/2011
    <blank> | 7/2/2011
    <blank> | <blank>

    Currently B2 (and B12 (w/MATCH target modified)) on the report tab have this entered,
    "'=INDEX(data!$A:$A,MATCH(A$2,data!$B:$B,0),1)", with A2 (and A12) hardcoded as "White Landcruiser", (and A12 as "Green Ford").

    Clearly the function that I am using does not provide all of the dates shown: it only provides a repeat of the initial date in following rows.

    Any suggestions regarding how I can list the date of occurrences of "type" from the data tab? Thanks in advance for advice and suggestions that use MATCH-INDEX to do this.
    Last edited by portsample; 07-27-2011 at 12:48 AM. Reason: clarity

  2. #2
    Valued Forum Contributor
    Join Date
    05-23-2011
    Location
    Lahore PK
    MS-Off Ver
    Excel 2007, 2013
    Posts
    627

    Re: Using MATCH-INDEX to list occuring dates of values in a data table

    Hi portsample

    find the attatched file with formula
    Attached Files Attached Files
    Azam
    If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
    For prompt answer, be descriptive, concise, short, direct, and to-the-point.

+ Reply to Thread

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