Excel 2007 : How to generate a list based on criteria

**fraggle** · 04-28-2009, 01:38 PM

Hello all,

Is there any way to have excel make a list of records in column A, based upon criteria in column B, C, D, etc? Each column A entry is unique, but the rest of the columns have many like entries. Thanks in advance.

**frankyJ** · 04-28-2009, 01:48 PM

Do you think you could post an example of your data and a description of what you want to do with it so we can better judge what kind of formula will work best?

**fraggle** · 04-28-2009, 02:22 PM

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.

**fraggle** · 04-29-2009, 09:40 AM

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

**aripori** · 05-20-2015, 01:55 AM

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

**aripori** · 05-20-2015, 02:04 AM

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

**José Augusto** · 05-20-2015, 04:29 AM

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

**Fotis1991** · 05-20-2015, 04:41 AM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.