Hi,

I have an issue bringing across data into a table.

In worksheet 1 I have my data, in worksheet 2, I have one table that needs
to be populated by only some of the data in worksheet 1.

The problem is that I have multiple sets of criteria that could meet each
cell in the table. For example, the first column in my table is simply a
name.

But, Not only do i need my table to show how many times the name appears in
worksheet 1 in a different row, but I also need it to seperate out each
individual name.

Example:

In worksheet 1 I may have something like this:


Column 1 Column 2
John Yes
Paul Yes
Stephen No
John Yes
Jason Yes
Paul No
John No
Bob Maybe


I need my table in worksheet 2 to look something like this (the criteria for
returning the value is Yes or Maybe):

Column 1
John
Paul
John
Jason
Bob

Any ideas?