Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Singling out searched cells
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Singling out searched cells
If all instances of Apples would be in one column use
DataFilterAutofilter. 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 On Mon, 26 Oct 2009 11:36:04 -0700, Lycean wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combination searched | Excel Worksheet Functions | |||
Can a column of data be searched from bottom to top | Excel Worksheet Functions | |||
VLOOKUP - returning the searched for value if it does not exist | Excel Discussion (Misc queries) | |||
Additional Columns to be Searched | Excel Discussion (Misc queries) | |||
VBA: Return Searched Value Inputed by End-User | Excel Worksheet Functions |