Singling out searched cells

  • Thread starter Thread starter Lycean
  • Start date Start date
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.
 
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
 
Back
Top