Hello Excel,
Looking for some assistance on the following problem:
I have a keyword in column "E" that goes down approximately 4,000 rows.
Columns A - D have the following rules
1. They contain no text
2. They contain the specific keyword in column "E"
3. It contains the specific keyword, but also contains other text in the cell.
How can I check columns A-D for the specific keyword in column "E" and return that in column "F". Please keep in mind I am doing this for 4,000+ rows.
I am essentially doing this to check if the four columns have this specific keyword somewhere in the 4 different columns with the above parameters.
Thank you to anyone who can help.
[TABLE="width: 632"]
<tbody>[TR]
[TD] [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
Looking for some assistance on the following problem:
I have a keyword in column "E" that goes down approximately 4,000 rows.
Columns A - D have the following rules
1. They contain no text
2. They contain the specific keyword in column "E"
3. It contains the specific keyword, but also contains other text in the cell.
How can I check columns A-D for the specific keyword in column "E" and return that in column "F". Please keep in mind I am doing this for 4,000+ rows.
I am essentially doing this to check if the four columns have this specific keyword somewhere in the 4 different columns with the above parameters.
Thank you to anyone who can help.
[TABLE="width: 632"]
<tbody>[TR]
[TD] [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]