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
Bookmarks