I have excel sheet which contain 100 and 100 of email and corresponding name. I need to seprate them according to the number of occurrence of their name.
excell sheet contain name and email, the work is we should found out
1.Total no of contact in excell sheet.
2. From that total number should find out single contribution(the name of person occurs only once)(only should consider the number time occurrence of persons name).
3.>=2,>=3,.......>=16,(its only up to 16 times occurrence of some name)
the findings should tally with the total number of list.
out put should be in another text
note: the same name will be written in different case,(Chandran,chandran), some time space (Hari chandran or harichandran) like
plz help me solve this problem..manually its difficult to find 1000 of names so plz help to do in programmatic. Because i know some basics in Perl so i can try..