View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tod tod is offline
external usenet poster
 
Posts: 114
Default Best way to get unique names

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