| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extract names based on conditions
In Excel I have a long list of names. I want to write a macro to extract all
those names that are a certain age into a new list eg if my spreadsheet shows A B 1 Name Age 2 Adam 40 3 Eve 28 4 Frank 40 5 John 43 I want to create the list of people aged 40 ie Adam, Frank in 2 new cells Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract domain names from email IDs | Excel Worksheet Functions | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Counting based upon 2 conditions that are text based | Excel Discussion (Misc queries) | |||
| Formula to Extract value on 3 column based on two conditions | Excel Discussion (Misc queries) | |||
| How do I extract the last name in Excel, from a list of names lik. | Excel Worksheet Functions | |||
Threaded Mode
