I'm not sure I understand your sample correct answers, so this might not be what you're after. (I don't know why there is an answer (Sam E, Kylie) and an answer (Sam E, Kirsten)), but

In cell L4:
=D4&E4&F4&G4&H4&I4&J4&K4


Copy down

In some column in row 4:
=IF(COUNTIF($L$4:$L$19,L4)>1,"Can't Win ("&C4&")","")
Copy down

Kimberly,

Thanks for your reply, you have almost got it, to explain why the end result should be - Can't Win (Sam.E, Kylie) next to Kirsten's name is it shows everyone that Kirsten, Sam.E & Kylie have all picked the same teams making them unable to win that week, the way you have got it working is the same name against that person but it should only say the other person or persons who has the same tips whether it be 1, 2, 3 or more people.

One other thing I noticed is if a person is away and does not put their tips in then the cell where it says can't Win etc should be blank where as if I leave a persons tips out it still shows - Can't Win (Mike) - should be a blank cell.

I look forward to your reply
Mike.