only return true values

[John M]

I want to only return the true values, in consecutive cells, from an IF
statement. Is this possible? Currently using an IF statement and I can't do
this.

E.G
A B C
John Male Mary
Mary Female Jane
Paul Male
Simon Male
Jane Female

In the above example I just want to return the names of all females.
therefore column C is my desired result. Any help appreciated...

 

[Dave Peterson]

How about an alternative?

Add headers in row 1
Select your range (A1:Bxxx)
Data|Filter|Autofilter
Use the arrow over the header in B1 to show just the females.

 

[Gary''s Student]

You don't need an IF statement, just use AutoFilter. You can display a
column of just female names, copy them, and paste them elsewhere.

 

[John M]

Sorry. The example below is just a basic example. the project I am working on
is more complex. Basically I want to return the desired values in another
sheet and where the conditional value changes it changes the results.

 

[Pete_UK]

Advanced Filter could probably do this for you. Debra Dalgleish has
some comprehensive notes here:

http://www.contextures.com/xladvfilter01.html

Hope this helps.

Pete

 

[John M]

Thanks Pete

yes this helps but it only works if i want the data that is copied over to
remain static. Any ideas on how if the data changes that it can be
automatically updated in the next sheet?

 

[Pete_UK]

I don't know of any automatic way to make filters become dynamic, other than
using a macro. Perhaps if you double-click on one of the criteria cells as
if to edit it, and then press <enter>.

Hope this helps.

Pete