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
 
check auto filter or advancedd filter to see if they will do what you want.
 
Maybe you could select your range and do
Data|filter|autofilter

Then filter to show the value that you want.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to retrieve multiple rows with one criteria 4
Access Dcount (multiple criteria) 3
Multiple criteria 3
Sumproduct with multiple criteria 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Inserting multiple rows 2
Delete rows based on certain criteria 2
Delete rows based on multiple criteria 6

Back
Top