hello,

First time user so sorry if this is a dumb question.

I have an excel sheet with 50 columns and 50 rows. Each cell has 3 initials in it. The initials represent a person on a timetable.

The problem I have is that each set of initials can only appear in each column once. i need to check this. If the initials appear twice then that person has to be in 2 places at the same time.

Is there an easy way to check each column and make sure that initils dont appear twice in a column ?

Northo