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

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

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