list of names??

[FLETCH515]

currently have in column A, a list of names. In column L, I have a "yes" or "no". What formula would I use to produce a list, in column N, of the names that are "no".? Any help would be appreciated

 

[kweaver]

Have you tried filtering the list using column L as NO? Then, copy and paste from the A column to N.

Or, in N: =IF("No" = L2,A2,"") and fill down then filter on N.

 

[Eric W]

kweaver's idea is probably the fastest, but if you need a formula, try:

Book1
	A	L	N
1	Name	Flag	No List
2	Amy	yes	Dan
3	Bob	yes	Eliza
4	Clara	yes	Giselle
5	Dan	no	Irene
6	Eliza	no	Jim
7	Fred	yes
8	Giselle	no
9	Hank	yes
10	Irene	no
11	Jim	no
12	Katy	yes
13
Sheet1

Cell Formulas
Range	Formula
N2	=IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($A$2:$A$20)/(($L$2:$L$20="no")*($A$2:$A$20<>"")),ROWS($N$2:$N2))),"")

 

[FLETCH515]

Thank you. I was using the filtering but was looking to use a formula to basically paste the list onto a separate tab, hiding all the raw data. I should have explained that in the beginning, but thank you again.

 

[FLETCH515]

I thought I was responding straight to kweavers post, and then I was going to respond to eric's but....

Eric Thank you. That was exactly what I needed. thank you once again both for responding

 

[Eric W]

Glad we could help.