Search for repeat words in Excel database
 

I have created a database in Excel that contains only text. Is there any way
that I can search for a particular word or phrase in the entire database and
have it displayed (by highlighting it for example)?

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein

Search for repeat words in Excel database
 

Edit Find your particular word


"Jackpine" wrote:

I have created a database in Excel that contains only text. Is there any way
that I can search for a particular word or phrase in the entire database and
have it displayed (by highlighting it for example)?

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein

Search for repeat words in Excel database
 

Yep, and you can use FORMAT: CONDITIONAL FORMATTING to highlight them in a
different colour

"Teethless mama" wrote:

Edit Find your particular word


"Jackpine" wrote:

I have created a database in Excel that contains only text. Is there any way
that I can search for a particular word or phrase in the entire database and
have it displayed (by highlighting it for example)?

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein

Search for repeat words in Excel database
 

Maybe something like this:

Put the search word or phrase in cell A1

Then
Select the database range
or
select from the upper-left cell of the database
across to the upper-right cell of the datase
and down through Row_65536
with the upper-left cell of the selected range active
(Assuming A5 is that cell)

Then
From the Excel main menu:
<format<conditional formatting
Formula is: =COUNTIF(A5,$A$1)
Click the [format] button and set the highlight
Click the [OK] buttons to finish

Now..all matched cells in the DB will highlight

NOTES:
If A1 begins with an asterisk (*).....the match is for "ends with"
*widget

If A1 ends with an asterisk (*).....the match is for "begins with"
widget*

If A1 begins AND ends with an asterisk (*).....the match is for "contains"
*widget*

If A1 DOES NOT use an asterisk (*).....the match is for the entered text
widget

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Jackpine" wrote:

I have created a database in Excel that contains only text. Is there any way
that I can search for a particular word or phrase in the entire database and
have it displayed (by highlighting it for example)?

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein

Search for repeat words in Excel database
 

Ron, I don't understand the following from your message:

- why do you mention Row_65536? What is that in reference to?

- why do you mention cell A5?

- It is not clear to me where I type the word/phrase that I am looking for.

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein


"Ron Coderre" wrote:

Maybe something like this:

Put the search word or phrase in cell A1

Then
Select the database range
or
select from the upper-left cell of the database
across to the upper-right cell of the datase
and down through Row_65536
with the upper-left cell of the selected range active
(Assuming A5 is that cell)

Then
From the Excel main menu:
<format<conditional formatting
Formula is: =COUNTIF(A5,$A$1)
Click the [format] button and set the highlight
Click the [OK] buttons to finish

Now..all matched cells in the DB will highlight

NOTES:
If A1 begins with an asterisk (*).....the match is for "ends with"
*widget

If A1 ends with an asterisk (*).....the match is for "begins with"
widget*

If A1 begins AND ends with an asterisk (*).....the match is for "contains"
*widget*

If A1 DOES NOT use an asterisk (*).....the match is for the entered text
widget

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Jackpine" wrote:

I have created a database in Excel that contains only text. Is there any way
that I can search for a particular word or phrase in the entire database and
have it displayed (by highlighting it for example)?

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein

Search for repeat words in Excel database
 

OK....here goes:

Q- why do you mention cell A5
A- Since you didn't indicate the range of your data list, I tried to make
the instructions easier by creating an example.

Q- why do you mention Row_65536? What is that in reference to?
A- Since I didn't know how large your data list was, I allowed for it to
extend to the last row of the worksheet. So, keeping with my example, if the
data list was in columns A through D, the I allowed for the matched items to
be anywhere in the range A5:D65536

Q- It is not clear to me where I type the word/phrase that I am looking for
A- The method I posted uses Conditional Formatting to highlight matched
items. Instead of having you re-select the data list and re-create the
condition, I had all CF cells compare themselves to the value in cell A1.
So...if you type a value in cell A1, data list cells that match that value
will highlight.

Post back with any other questions.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jackpine" wrote:

Ron, I don't understand the following from your message:

- why do you mention Row_65536? What is that in reference to?

- why do you mention cell A5?

- It is not clear to me where I type the word/phrase that I am looking for.

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein


"Ron Coderre" wrote:

Maybe something like this:

Put the search word or phrase in cell A1

Then
Select the database range
or
select from the upper-left cell of the database
across to the upper-right cell of the datase
and down through Row_65536
with the upper-left cell of the selected range active
(Assuming A5 is that cell)

Then
From the Excel main menu:
<format<conditional formatting
Formula is: =COUNTIF(A5,$A$1)
Click the [format] button and set the highlight
Click the [OK] buttons to finish

Now..all matched cells in the DB will highlight

NOTES:
If A1 begins with an asterisk (*).....the match is for "ends with"
*widget

If A1 ends with an asterisk (*).....the match is for "begins with"
widget*

If A1 begins AND ends with an asterisk (*).....the match is for "contains"
*widget*

If A1 DOES NOT use an asterisk (*).....the match is for the entered text
widget

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Jackpine" wrote:

I have created a database in Excel that contains only text. Is there any way
that I can search for a particular word or phrase in the entire database and
have it displayed (by highlighting it for example)?

Thanks.
--
Not all those who wander are lost.

J. R. R. Tolkein