| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
only return true values
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... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only return true values
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. -- Gary''s Student - gsnu200778 "John M" wrote: 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... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only return true values
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. "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200778 "John M" wrote: 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... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only return true values
Advanced Filter could probably do this for you. Debra Dalgleish has
some comprehensive notes he http://www.contextures.com/xladvfilter01.html Hope this helps. Pete On Apr 10, 3:52*pm, John M wrote: 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. "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200778 "John M" wrote: 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...- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only return true values
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" wrote: Advanced Filter could probably do this for you. Debra Dalgleish has some comprehensive notes he http://www.contextures.com/xladvfilter01.html Hope this helps. Pete On Apr 10, 3:52 pm, John M wrote: 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. "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200778 "John M" wrote: 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...- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only return true values
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 "John M" wrote in message ... 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" wrote: Advanced Filter could probably do this for you. Debra Dalgleish has some comprehensive notes he http://www.contextures.com/xladvfilter01.html Hope this helps. Pete On Apr 10, 3:52 pm, John M wrote: 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. "Gary''s Student" wrote: 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. -- Gary''s Student - gsnu200778 "John M" wrote: 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...- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
only return true values
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. John M wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if multiple values same/others different, return true | Excel Discussion (Misc queries) | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| Look up to return a true/false value | Excel Worksheet Functions | |||
| Function to return True/False if all are validated as True by ISNU | Excel Worksheet Functions | |||
| How do I return True False | Excel Worksheet Functions | |||
![John M[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
