How do I return multiple occurrences of a match in an array?

U

Umbu

Hi All:

Say I have the following array:

Product Salesperson Apr May Jun Jul Aug
X100 J. Smith 2 4 3 5 6
X100 S. Jones 2 3 4 3 4
X100 T. Fields 1 3 2 4 5
X100 F. Tucker 3 4 4 5 6
X200 J. Smith 1 3 2 4 5
X200 S. Jones 3 4 4 5 6
X200 F. Tucker 1 3 2 4 5

I want to use a function that returns all occurrences of June data for
product X100 for all salespeople. That is, I want to return the following:

Product Salesperson Jun
X100 J. Smith 3
X100 S. Jones 4
X100 T. Fields 2
X100 F. Tucker 4

Can anyone suggest a method of doing this? Note that the array heights can
vary as not all salespeople will forecast on a specific product.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX return multiple columns 1
how do I use array references in VLOOKUP()? 2
Counting number of occurrences. 1
How do I have excel highlight days before & after a date on a cale 2
Which Function(s) should I use? 7
return multiple rows of data based on criteria 7
Sum multiple colums of data 5
copy data for match word from one file to another file 1

Top