Hi all,
i have data sheet containing customer feedback, column H of this sheet contians feedback text. there are 4500 rows and i have to search 12 keywords in each cell(H2 t0 H4500). the key words are -
Unhappy
Declined
Dissatisfied
Frustrated
Frustrating
Unreasonable
Increase in margin
Competitor
Error
Bad
Charges
Mistake.
if any of these or more than one word found in respective cell then macro should return the text in Adjucent right cell.
thanks in advance
i have data sheet containing customer feedback, column H of this sheet contians feedback text. there are 4500 rows and i have to search 12 keywords in each cell(H2 t0 H4500). the key words are -
Unhappy
Declined
Dissatisfied
Frustrated
Frustrating
Unreasonable
Increase in margin
Competitor
Error
Bad
Charges
Mistake.
if any of these or more than one word found in respective cell then macro should return the text in Adjucent right cell.
thanks in advance
Last edited: