**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.*