Formula to check if Cells contain 3 given texts

[VPLUMWOOD]

Im organising a training day where staff have 11 workshops to choose from,

They have all chosen their top 3 so I have allocated them a Session 1, Session 2 and Session 3 choice.

I want a formula at the end that tells me if Session1, Session2 and Session3 are included in the range D2:H2 so I can make sure I haven't accidentally assigned anyone Session1, Session1, Session3 etc i.e. 2 sessions with the same number. The rows wont always be in order i.e. might have session2, session1, session 3 but all together all 3 are there.

Any ideas?

Short

Mapplewell

Session2

Music

Session3

Art

Session1

DT

Gregory

Hoyland Common

Session1

EYFS

Session2

MFL

Session3

Art

 

[Fluff]

These all say OK but when I've changed one so there is a duplicate to test it still showed OK?

You can see from the data I posted that the formula works as there is Duplicate in I2

 

[RobP]

maybe I should post mine so you can see mine works too ...

 

[hrayani]

Its worked using the =IF(OR(C2=E2,C2=G2,E2=G2),"Duplicate Session","All OK")