Syar sahib agr aik cell ko 2 ranges se match karna ho for duplication and uniqueness then formula kya banay ga
jaisa kah ap nay formula btaya

=if(isnumber(match(c2;range;range;0)); "duplicate";"Unique")

The above formula will work for this or not.

Thanks