| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to retrieve multiple values in multiple rows with one criteria
Hi
Can anyone please help me with this question. I would like to type a code in a cell and would like to extract all the rows with that code. Is this possible or do I need VBA or is there a formula that can do this? Thanks Bac |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retrieve multiple values in multiple rows with one criteria
check auto filter or advancedd filter to see if they will do what you want.
"bac" wrote: Hi Can anyone please help me with this question. I would like to type a code in a cell and would like to extract all the rows with that code. Is this possible or do I need VBA or is there a formula that can do this? Thanks Bac |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to retrieve multiple values in multiple rows with one criteria
Maybe you could select your range and do
Data|filter|autofilter Then filter to show the value that you want. bac wrote: Hi Can anyone please help me with this question. I would like to type a code in a cell and would like to extract all the rows with that code. Is this possible or do I need VBA or is there a formula that can do this? Thanks Bac -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| retrieve multiple results with one criteria... | Excel Discussion (Misc queries) | |||
| Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
| Count Unique Values with Multiple Criteria | Excel Worksheet Functions | |||
| Summing Rows with Multiple Criteria | Excel Worksheet Functions | |||
| How can I retrieve multiple rows that match one criteria, i.e. a d | Excel Worksheet Functions | |||
Linear Mode
