imdb project

asking third time ?? please reply ..i have bifurcated each genres in different columns but not able to find unique genres....i have tried to use remove duplicates functions by selecting the range but it gives me repeated results of genres..how to calculate the unique values?