View Single Post
 
Old 07-11-2011, 10:40 AM
Kimberly Kimberly is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

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
Reply With Quote