List rows

  • Thread starter Thread starter tapnawk99
  • Start date Start date
T

tapnawk99

I have simple excel like
A B C
1 apple $10 USA
2 Orange $20 Africa
3 Apple $5 China

And I want another sheet to insert e.g. "apple" it will returns the
whole rows which match
"apple"


apple $10 USA
Apple $5 China
 
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

lookup and return column number 2
max 7
Macro to add Multiple rows in same sheet 1
Another Running Totals Problem 9
"select distinct" in Excel 3
Retrieve Column Header for Specific Data in a Row 3
Reducing repetitive calculation not working 1
How to create a Pivottable with text only data 1

Back
Top