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