The above information has been entered into the table with a lot of volumes to be formulated. Please let us know the way in Excel

Hi Ali

Please give more examples in an attached workbook.

APPL and APPLS are not identical.

You can try using a Pivot Table to do what you wanted.

Sunny

Using a Filter option you can find identical sentences.

Hi Ali,

I'm confused.  The topic title is 'Search for non-similar words in Excel', but your post asks to find indentical sentences.  Which one is it?

If you want to find identical/duplicate strings you could try conditional formatting to highlight duplicates

Or if you have your data in a table, filters could be an option as Kevin said

or Pivot Tables as Sunny mentioned.

Without seeing all of your data I can't give the best answer.  Please supply a workbook and clarify what you want to do.

Regards

Phil