Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to find similarities in one column of excel data (12,000 rows) that would clearly indicate the cells that are extremely similar to another cell, even if not a direct match. I tried fuzzylookup and that would not work as well as the conditional formatting rules.
Solved by T. C. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
11/06/2018 - 01:39
Hi
Excelchat Expert
11/06/2018 - 01:39
Welcome to Got it Pro
User
11/06/2018 - 01:39
thanks, can you help me
Excelchat Expert
11/06/2018 - 01:39
Can you elaborate on your requirement so that i can help
Excelchat Expert
11/06/2018 - 01:41
DO you have some sample data so that i can help
User
11/06/2018 - 01:41
I need to create one list of company names. Currently I have a list of 12,000 with similairites and matches within the data. However, the data doesn't have any exact matches anymore due to differences with text input. I need to narrow down the list to make sure the company only appears once and need a formula to clearly indicate what cells are the same
User
11/06/2018 - 01:41
no I dont
User
11/06/2018 - 01:42
if you look at the document preview, that's the idea I'm talking about. They are all clearly ace but not exact matches
Excelchat Expert
11/06/2018 - 01:43
please explain what do you want
User
11/06/2018 - 01:44
I want a formula that will make it clear that two cells are basically the same even if they arent an exact match
User
11/06/2018 - 01:46
???
Excelchat Expert
11/06/2018 - 01:47
how would want them to be clear?
Excelchat Expert
11/06/2018 - 01:47
Do you want to split these up?
User
11/06/2018 - 01:47
I want the cells to be highlighted or sent to a new list to indicate they are similar
Excelchat Expert
11/06/2018 - 01:48
Can you explain through an example?
User
11/06/2018 - 01:48
Can you see the document preview?
Excelchat Expert
11/06/2018 - 01:48
yes
User
11/06/2018 - 01:49
Notice how they are all ace?
Excelchat Expert
11/06/2018 - 01:49
Yes
User
11/06/2018 - 01:49
but they all indicate that they're ace with a different textual input
User
11/06/2018 - 01:50
imagine I have a list of 12,000 cells. With various cells that have information similar to the ace example.
User
11/06/2018 - 01:51
I want to find a way that I could easily point out that there are similarities within the huge list that I need to look more closely at
Excelchat Expert
11/06/2018 - 01:51
Do you want to seperate Ace and the next word?
Excelchat Expert
11/06/2018 - 01:51
would that help?
Excelchat Expert
11/06/2018 - 01:53
Do you see column C, and D
Excelchat Expert
11/06/2018 - 01:53
Would that help?
Excelchat Expert
11/06/2018 - 01:54
i need to know what exactly you want..how you want to use the data so that i can help you with the exact requirement
User
11/06/2018 - 01:55
thanks that helps
Excelchat Expert
11/06/2018 - 01:55
great
Excelchat Expert
11/06/2018 - 01:55
Please do give good rating and review
Excelchat Expert
11/06/2018 - 01:55
It would certainly help a lot
Excelchat Expert
11/06/2018 - 01:55
Have a great day
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.
