Formula to check if Cells contain 3 given texts

V

VPLUMWOOD

New Member
Joined
Jul 13, 2021
Messages
41
Office Version
  1. 365
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?

ShortMapplewellSession2MusicSession3ArtSession1DT
GregoryHoyland CommonSession1EYFSSession2MFLSession3Art
 
Sort by date Sort by votes
VPLUMWOOD said:
These all say OK but when I've changed one so there is a duplicate to test it still showed OK?
Click to expand...
You can see from the data I posted that the formula works as there is Duplicate in I2 ;)
 
Upvote 0

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
maybe I should post mine so you can see mine works too ... ;)
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,221,547
Messages
6,160,456
Members
451,647
Latest member
Tdeulkar

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top