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.
Bookmarks