Question description:
This user has given permission to use the problem statement for this
blog.
I want to find cells in which a word is duplicated. For example if A1 contains "house fish car house" it should be highlighted because "house" is double. The words can be in any position inside the cell so it could be "house house fish car" or "car house fish house"
Solved by Z. B. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/04/2018 - 11:46
Hi
User
06/04/2018 - 11:47
Hi
Excelchat Expert
06/04/2018 - 11:47
Welcome to Got it Pro
User
06/04/2018 - 11:47
Thanks
Excelchat Expert
06/04/2018 - 11:47
I understand your requirement.
Excelchat Expert
06/04/2018 - 11:48
do you have any excel sheet?
User
06/04/2018 - 11:48
no but i can paste some rows in
Excelchat Expert
06/04/2018 - 11:48
ok. Please create
User
06/04/2018 - 11:49
unfortunately i cant format the cells
User
06/04/2018 - 11:49
it should be formatted as text
Excelchat Expert
06/04/2018 - 11:49
No problem
Excelchat Expert
06/04/2018 - 11:50
Can you paste again
Excelchat Expert
06/04/2018 - 11:51
Do paste special Values
Excelchat Expert
06/04/2018 - 11:52
Thank you
Excelchat Expert
06/04/2018 - 11:52
No tell me.
Excelchat Expert
06/04/2018 - 11:52
*Now tell me.
User
06/04/2018 - 11:52
so if in one of thes cells a word is double, i need it to be highlighted
User
06/04/2018 - 11:53
im searching an example
Excelchat Expert
06/04/2018 - 11:53
Any example cell.
User
06/04/2018 - 11:53
743
User
06/04/2018 - 11:53
the word "Aarau is double
Excelchat Expert
06/04/2018 - 11:53
Aarau?
Excelchat Expert
06/04/2018 - 11:53
Oh ok.
Excelchat Expert
06/04/2018 - 11:54
Do you want to search specific test in all the rows.
Excelchat Expert
06/04/2018 - 11:54
or any words repeated two time you would like to highlight
User
06/04/2018 - 11:54
the second, any word
User
06/04/2018 - 11:54
if thats not possible we can also do specific test
User
06/04/2018 - 11:54
but i'd rather have any word
Excelchat Expert
06/04/2018 - 11:55
Specific Test is possible
User
06/04/2018 - 11:55
okay
Excelchat Expert
06/04/2018 - 11:55
One minute
Excelchat Expert
06/04/2018 - 12:00
Please Check this
[Uploaded an Excel file]
Excelchat Expert
06/04/2018 - 12:01
Are you there?
User
06/04/2018 - 12:02
yes
Excelchat Expert
06/04/2018 - 12:02
Please Check example I am searching word Aarau
Excelchat Expert
06/04/2018 - 12:02
I have displayed the result in Column E
User
06/04/2018 - 12:03
ah i see
User
06/04/2018 - 12:03
its case sensitive right?
Excelchat Expert
06/04/2018 - 12:03
Yes. Do you want Ignore Case Sensitive?
User
06/04/2018 - 12:03
if possible
Excelchat Expert
06/04/2018 - 12:04
ok . 2 minutes
Excelchat Expert
06/04/2018 - 12:04
Please extend the time
User
06/04/2018 - 12:04
where?
Excelchat Expert
06/04/2018 - 12:05
No need fixed
[Uploaded an Excel file]
Excelchat Expert
06/04/2018 - 12:05
Request you to provide valuable feedback and session going to end within 1 minute
Excelchat Expert
06/04/2018 - 12:05
It will ignore case sensitive.
User
06/04/2018 - 12:05
I will
User
06/04/2018 - 12:05
thanks!
Excelchat Expert
06/04/2018 - 12:06
welcome :)
Excelchat Expert
06/04/2018 - 12:06
Please connect with us again If you need any support.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.