I have a table of data in a worksheet, like this:

Name Applies
Fred 0
Joe 0
Greg 1
Joe 1
Fred 1
Mary 1
Joe 1
Fred 1
Fred 0

I'm trying to get a unique list of Names where Applies =
1 and paste that list to another sheet. Everything I've
tried is just too sloppy. Can anyone suggest a way to do
this?

tod

Hi
try using 'Data - Filter - Advanced Filter' and check unique entries. You
may first filter out all entries without a '1' in column B

"Tod" wrote:

I have a table of data in a worksheet, like this:

Name Applies
Fred 0
Joe 0
Greg 1
Joe 1
Fred 1
Mary 1
Joe 1
Fred 1
Fred 0

I'm trying to get a unique list of Names where Applies =
1 and paste that list to another sheet. Everything I've
tried is just too sloppy. Can anyone suggest a way to do
this?

tod

You can use an Advanced Filter to extract the names

With your sample data in cells A1:B10 --

Set up a criteria area:
In cell D1, type: Applies
In cell D2, type: 1
In cell E2, type: =SUMPRODUCT((A$2:A2=A2)*(B$2:B2=1))=1

Set up the Extract area:
In cell G1, type: Name

Select a cell in the list, and choose DataFilterAdvanced Filter
Select to Copy to another location
For the list range, select A1:B10
For the criteria area, select D1:E2
For Copy to, select G1
Click OK

Tod wrote:
I have a table of data in a worksheet, like this:

Name Applies
Fred 0
Joe 0
Greg 1
Joe 1
Fred 1
Mary 1
Joe 1
Fred 1
Fred 0

I'm trying to get a unique list of Names where Applies =
1 and paste that list to another sheet. Everything I've
tried is just too sloppy. Can anyone suggest a way to do
this?

tod


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html