Log In
Register
Home
New Member
January 20, 2019
Offline
Find two identical sentences with two distinct codes in Excel: Example below:
CODE PRODUCT
1202 APPL
1205 APPLS
Please advise if you have an answer
New Member
January 20, 2019
Offline
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
VIP
Trusted Members
June 25, 2016
Offline
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
New Member
February 21, 2019
Offline
Using a Filter option you can find identical sentences.
October 5, 2010
Offline
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
1 Guest(s)
