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
>
>