Singling out searched cells

L

Lycean

I'm creating a customer database, and I would like to be able to search for
values and ONLY show those that match. For instance, if I search for Apples,
I only get the lines with cells containing "Apples". Right now, with ctrl + F
it only shows me where they are in the document, I need it to acutally
isolate the rows.
 
G

Gord Dibben

If all instances of Apples would be in one column use
Data>Filter>Autofilter.

If more complex than that post back with some details.

Could Apples be in several different columns?

Could Apples appear twice in the same row?


Gord Dibben MS Excel MVP
 

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

Dynamic Filtering 2
How do I LOOKUP text values 4
Subtotal counting formula in cells 1
Decimal rounding causing addition errors 2
Find - Entire Cells only 2
Finding cells with a value ending in '.0' 6
Auto filter for multiple columns 2
Alternative to ADDRESS function 1

Top