only return true values

  • Thread starter Thread starter John M
  • Start date Start date
J

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...
 
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.
 
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.
 
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.
 
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?
 
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
 
Back
Top