| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you create a Macro to return text from multiple cells that fit your criteria?
Does anyone know how you create a Macro to return text from multiple
cells that fit your criteria? Let's say you have a worksheet with 100 records of people's names and various information about them (job, age, salary, etc.). You want to create a Macro that will return the names of everyone who fit a set of criteria you specify, i.e. Lawyers, or Doctors AND over 50 years old, etc. Does anyone know how to do this? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match / Index multiple criteria return multiple results | Excel Worksheet Functions | |||
| 2 criteria lookup of text. Return text form column 3. SUMPRODUCT t | Excel Worksheet Functions | |||
| Create macro to filter on multiple criteria | Excel Worksheet Functions | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| Macro to Create text file from range of cells? | Excel Programming | |||
Threaded Mode
