Data validation for Multiple columns
 

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

Hi,

sorry for bothering you all

but i got a solution on other group
here is link for others reference

http://groups-beta.google.com/group/...6deb2e1eb760d6

Best regards
NC

Hi ,

You can simple validation. =COUNTIF(A:A,A1)=1

regards
vishu

"NC" wrote:

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