• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Compare Data

S

SRINATH SOMAYAJI

New Member
i am having around 5000 row data in 2 columns, namely "A" (data downloaded from Billing Software) & "B" (data downloaded from Tally Software).

Now i want to compare two data mentioned in column "A" & "B" and put them in Column "C", the problem what i am facing is slight mis-match in name, example in column "A", the company name mentioned as ABCD Pvt. Ltd. where as in column "B" it is mentioned as ABCD Private Limited,

Please llet me know formula or macro to capture data in column "C".

Regards
Srinath Somayaji
 
Hi, SRINATH SOMAYAJI!

As a new user you might want (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, there's no straight method to achieve that issue, usually called data normalization or standardization. You'd better Google for fuzzy logic algorithms, but they'll all work by approximations, i.e., with one method you'd get the 70%, then with another a 10% more, and so... in real life, sometimes you end (or sometimes start) doing it manually, depending on the number of data fields.

Regards!
 
@SRINATH SOMAYAJI

Welcome to Chandoo.org glad you are here,

as a blind shot please try this

Code: 
 =INDEX(B:B,MATCH($A1,A:A,0))

May be it solve other wise please upload a sample file

Note:
Ooops 3 minute late from SirJB7
 
I am a moderate Excel user. I generally take data from vendor reports, sort it and package it for use by someone else to do more in depth analysis. I am new to the forum as posting goes but have been visiting the site for some time to find solutions to various problems I run across to get the data ready for use upstream.
 
I do basic reports in Excel mostly with already formatted data so I just have to sort it and dispaly costs after the sorting and them pass the data along to someone for more analysis.
I have a new project where I have to find matches between the Caller list and the Agent list. I have attached a file with a sample of what I am working with. The agent list has names as shown on a driver's license while the caller list is what is given to an operator at the time of the calls. A sample file is attached with correct match in Green.
The problemis the caller may go by First name - Last name, Middle Name - Last Name, or Nickname - Last name. I have your conditional formatting trick to find matches but the lists were virtually identical.
I need to remove spaces between the last name and the comma separating the last name from the first name. I use Trim but not for spaces in the middle.
 

Attachments

  • Compare_names.xlsx
    25 KB · Views: 3
You must log in or register to reply here.
Back
Top