Excel 2007 : How to generate a list based on criteria

Here is an example sheet. Basically, I would like to generate a list of names from column A if column B = Granby. I would like to do for each column.

Thanks to everyone who looked. I have the answer, modified from http://office.microsoft.com/en-us/ex...260381033.aspx

hi
i need below result pls give a solution
RESULT RESULT
COLOR LAB WASH PRINT EMBO S-TAPE N-TAPE OK NOT OK
BLACK OK NOT OK OK OK NOT OK OK BLACK=LAB&PRINT&EMBO&N-TAPE BLACK=WASH,S-TAPE
WHITE NOT OK OK NOT OK NOT OK OK NOT OK WHITE=WASH,S-TAPE WHITE=LAB,PRINT,EMBO,N-TAPE

thanks
Aripori

hi
i need below result pls give a solution
RESULT RESULT
COLOR LAB WASH PRINT EMBO S-TAPE N-TAPE OK NOT OK
BLACK OK NOT OK OK OK NOT OK OK BLACK=LAB&PRINT&EMBO&N-TAPE BLACK=WASH,S-TAPE
WHITE NOT OK OK NOT OK NOT OK OK NOT OK WHITE=WASH,S-TAPE WHITE=LAB,PRINT,EMBO,N-TAPE

thanks
Aripori

Hi
I send the file with a possible solution.
Note that the formulas placed in K3: P3 and Q3: v3 are array formulas and should confirm with Ctrl + Shift + Enter
Regards