how to stop the repeat names

Originally Posted by ancherilvm

yes, I want the alert for same names are in the row

In that case, disregard the suggestion from post #4.

see the attached book. but there is a problem how can I avoid blank cells. if there is no names. see attached spread sheet
I used this formula =$E4 = $H4