Here is the problem.
I have the list of MPs (members of parliament) and their attendance
register. I just wanted to see which party records better attendance and which
states register better attendance.
But the problem is the mapping the names of these MPs from
the two lists. One lists has the name Chowdhary,Smt.
Santosh and the other list has Smt
Santosh Chowdhary. (Notice the , and . after Smt)
These differences in Names will not
allow me to map the names from two lists.
Get the two lists in the same sheet.
Make sure they are two different tables.
Click on go. Make sure the active cell is I an empty cell with
enough space to populate the matched columns.
And boom! There it is….
Smt Santosh Chowdhary and Chowdhary,Smt.
Santosh are matched. It also gives you percentage of similarity. So you
can easily pick the wrong matches. (if there are)
No comments:
Post a Comment