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
|