Hi!

I have 2 columns of data.

first column is filled with names and the second is filled with a team number like: Team 1, Team 2, Team 3, etc.

These columns are filled in by users through a form. The problem is that users accidentally fill in the wrong team number. So some of the data will come out like in the example below.

Names Teams
Name 1 Team 1
Name 1 Team 2
Name 1 Team 2
Name 2 Team 3

So 'Name 1' made a mistake with filling in 'Team 1' and it suppose to be 'Team 2'.

It would be enough for me if I can just get an alert when there is a name connected with more then one team. I could change the values manually. Solutions in VBA or formula's in other column are both welcome.

Thanks in advance.