LINGSAEED
asked on
NAME VALIDATION SOFTWARE
I am working on a project where i have to check name is correct or not its very big file like 35000 record. i have to go one by one to check name is correct or not. is there any software where i upload my name and its give me a not a valid name list.
thanks
thanks
If there aren't too many other columns, you could use Excel to do a lookup once the 35000 names are in.
ASKER
what you mean by lookup in excel . it will tell me its correct person name .
Excel lets you look up a value in an array:
=VLOOKUP(testvalue, range_of_names, offset, FALSE)
testvalue is the name you want to test
range_of_names is the list of names to check against
offset is 1 if all you want is the name
FALSE will force it to display #N/A if it doesn't find it, otherwise, it will display the name
=VLOOKUP(testvalue, range_of_names, offset, FALSE)
testvalue is the name you want to test
range_of_names is the list of names to check against
offset is 1 if all you want is the name
FALSE will force it to display #N/A if it doesn't find it, otherwise, it will display the name
ASKER
can you explain me how i will do it in excel step by step . i have a name 35000 i want to check the name is correct or not .
thanks
thanks
Import all the names into Excel - let's say you put them in range A1..A35000. Use Excel to sort them alphabetically if they are not sorted, using Data->Sort.
In cell B1, put the name you want to test against the records.
In cell C1, put in the formula =VLOOKUP(B1,A$1..A$35000,1 , FALSE)
C1 will display the name if it finds it; otherwise, it will display #N/A
You can do this for each name you have to test by copying cells B1 and C1.
In cell B1, put the name you want to test against the records.
In cell C1, put in the formula =VLOOKUP(B1,A$1..A$35000,1
C1 will display the name if it finds it; otherwise, it will display #N/A
You can do this for each name you have to test by copying cells B1 and C1.
ASKER
You are try to tell me i have to have a correct name list in colum B . Where i will get correct name . i am getting a excell with name that is not correct and i have to go each record and check its correct name or not.
thanks
thanks
Well, how are you going to know if a name is spelled correctly? A computer has to look this up somewhere, and that means you or some other source.
ASKER
what my question is there any software where i can test against that database.
thanks
thanks
Ok, so you want a name database to compare against? That will be very difficult, because names can be spelled differently and still be correct. Some people have names that are deliberately different than common spelling. How are you doing this manually, and how do you know if the spelling is right?
ASKER
Thats a problem if i can narrow the error .
so i have to have a correct name list. then i will check my name against that list.
thanks
so i have to have a correct name list. then i will check my name against that list.
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.