Data validation for Multiple columns

  • Thread starter Thread starter NC
  • Start date Start date
N

NC

Hi all,

I am creating a spreadsheet which will have data entry from different
users.

I want to give the validation in such a way that a combination of
values in 2 columns do not occur more than once.

Like say
A B
1 a
1 b
2 a
2 b
2 a

in above example the combination 2 and a is recurring. it should be
restricted by validation while entering the data itself.

can anybody please help

Regards
NC
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Multiple Data Validation 7
Conditional Data Validation 2
Conditional Data Validation Options 2
custom data validation on cells with data validation values 2
Excel Target.column for Data Validation would like to target some cells within column 1
Multiple choices from lists of valid data 1
Data Validation using Unique Values 2

Back
Top