Is there a limitation of Match function ??
I have around 50 names and when i try to use the match function on them, it gives me unexpected results.....
E.g.
below is the list :
Sumathi Rajan
Lavina Veigas
Mohammed Ansari
Sagar Arora
Pravin Mandlik
Shainaz Khan
Sweeta Monteiro
Pervez Sayed
Shilpa Kudekar
Manjumol Nair
Lily Fernandes
Zeenia Pinto
Prashant Bhat
Sabrina Patel
Sachin Jadhav
Sachin Masal
If i try to use the match function with this list on Shainaz Khan, it gives back 11 (instead of 6)...
I have around 50 names and when i try to use the match function on them, it gives me unexpected results.....
E.g.
below is the list :
Sumathi Rajan
Lavina Veigas
Mohammed Ansari
Sagar Arora
Pravin Mandlik
Shainaz Khan
Sweeta Monteiro
Pervez Sayed
Shilpa Kudekar
Manjumol Nair
Lily Fernandes
Zeenia Pinto
Prashant Bhat
Sabrina Patel
Sachin Jadhav
Sachin Masal
If i try to use the match function with this list on Shainaz Khan, it gives back 11 (instead of 6)...