ColourfulFigsnDiags
Chemical
Hi all!
I've got a database which lists (wait for it) the contents of boxes. Each row contains the details of a particular file within a particular box. Associated with each file are key-words, which are stored in a cell. For example, one of the keyword columns is for what chemicals the particular file deals with, so the cell might contain, "Ammonia, air, nitric acid".
I would like to be able to display all files which contain the key word "Ammonia". Unfortunately, because the keyword appears in a cell with other key words, I cannot use the Auto filter to do this.
Does anyone know of an easy method to do this?
Read the Eng-Tips Site Policies at FAQ731-376
I've got a database which lists (wait for it) the contents of boxes. Each row contains the details of a particular file within a particular box. Associated with each file are key-words, which are stored in a cell. For example, one of the keyword columns is for what chemicals the particular file deals with, so the cell might contain, "Ammonia, air, nitric acid".
I would like to be able to display all files which contain the key word "Ammonia". Unfortunately, because the keyword appears in a cell with other key words, I cannot use the Auto filter to do this.
Does anyone know of an easy method to do this?
Read the Eng-Tips Site Policies at FAQ731-376