How to retrieve multiple values in multiple rows with one criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Maybe you could select your range and do
Data|filter|autofilter

Then filter to show the value that you want.
 
Back
Top