Column Values Pronouncing same then y or n

Question

I am supporting to one e governence project in telugu language and names are in english. My requirement is if names are matchning status is 'Y' else 'N' , i have used Difference () function but the result is not accurate as expected. How can we acheive it?

 

B DEEPTHI	y	B.Deepthi
GURRAM HIMA BINDU	y	Gurram Himabindu
S SINDHU	y	S. Sindhu
Y PRUDVI KRISHNA	y	Y. Prudvi Krishna
YERRAYAMMA NANGIREDDY	n	Nahgireddy Simhadri
yerrayamma pittala	y	Pittala Errayamma
Yerrayamma seedari	n	Seedhari Lovaraju
Yerrayyamma bandaru	n	bandaru Dongodu