yeah. I've got about 15 minutes yet. I'll write up a hurry up already up on Abu something VictoriaNames and addresses can be very funky when you're dealing with large databases. I might have figured a solution to fine records that are most similar.
I don't know if this is possible. Not even logically without building a specialized search engine.
Example
Name-A2 Address-B2 Zip-E2 The Following was in Columns but it did not work. I separated the columns with a "-".
Snow, Bob-N101W15754 Council-53221
Bob & Vickie Snow-N101 W15754 Council-5322
Snow, Doug -Council Bluff W157-53221
Snow Robert-101 15754 NW- 53
Smith Tom-w123 St-5422
Smith T-123-542
When looking at thousands of records there are countless patterns. If I use something like a contain it would work all right for Smith that has a common value: Smith - 123 - 542. But in the case of Snow the value in the same feels are different from Smith: Snow - 157 - 53. Since there is an inequality . I would like to put that equality, Snow - 157 - 53, in a column AH2.
This might be a pipe dream, but here's hoping.
Bob
I don't know if this is possible. Not even logically without building a specialized search engine.
Example
Name-A2 Address-B2 Zip-E2 The Following was in Columns but it did not work. I separated the columns with a "-".
Snow, Bob-N101W15754 Council-53221
Bob & Vickie Snow-N101 W15754 Council-5322
Snow, Doug -Council Bluff W157-53221
Snow Robert-101 15754 NW- 53
Smith Tom-w123 St-5422
Smith T-123-542
When looking at thousands of records there are countless patterns. If I use something like a contain it would work all right for Smith that has a common value: Smith - 123 - 542. But in the case of Snow the value in the same feels are different from Smith: Snow - 157 - 53. Since there is an inequality . I would like to put that equality, Snow - 157 - 53, in a column AH2.
This might be a pipe dream, but here's hoping.
Bob
Last edited:
