| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Formulas for logical functions
Okay, REALLY frustrated here, and hope someone can help. I have the
following table: Section Name Phone Office 24 Mr Jones 4588 157-200 36 Ms Smith 3587 303-211 etc.... I have a list of 250 names, in 10 different sections. I would like to somehow have excel automatically pull and group everyone from the same section. Any ideas of how I can accomplish this? I've been wracking my brain trying to accomplish this, trying in 3 different programs, and MY BRAIN HURTS! Please help me... ~judi |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel Formulas for logical functions
Can't you just sort the data and/or use data|filter|autofilter?
Judi wrote: Okay, REALLY frustrated here, and hope someone can help. I have the following table: Section Name Phone Office 24 Mr Jones 4588 157-200 36 Ms Smith 3587 303-211 etc.... I have a list of 250 names, in 10 different sections. I would like to somehow have excel automatically pull and group everyone from the same section. Any ideas of how I can accomplish this? I've been wracking my brain trying to accomplish this, trying in 3 different programs, and MY BRAIN HURTS! Please help me... ~judi -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical functions If, And | Excel Discussion (Misc queries) | |||
| Logical Functions | Excel Discussion (Misc queries) | |||
| logical functions | Excel Worksheet Functions | |||
| logical formulas in excel | Excel Discussion (Misc queries) | |||
| logical functions | Excel Worksheet Functions | |||
Linear Mode
