Can i incorporate your code into my formula
=IF(jobsApplicationdb!G36='Person Specification'!$F$7,IF(FIND(jobsApplicationdb!I36,'Person Specification'!$H$7),IF(FIND(jobsApplicationdb!H36,'Person Specification'!$G$7),IF(ISTEXT(jobsApplicationdb!J36),IF(AND(jobsApplicationdb!P36='Person Specification'!$N$7,jobsApplicationdb!Q36='Person Specification'!$O$7,jobsApplicationdb!R36='Person Specification'!$P$7,jobsApplicationdb!S36='Person Specification'!$Q$7,jobsApplicationdb!T36='Person Specification'!$R$7,jobsApplicationdb!M36>='Person Specification'!$L$7,jobsApplicationdb!AJ36="Yes",jobsApplicationdb!U36>='Person Specification'!$S$7,jobsApplicationdb!W36>='Person Specification'!$U$7,jobsApplicationdb!Y36>='Person Specification'!$W$7,jobsApplicationdb!AA36>='Person Specification'!$Y$7,jobsApplicationdb!AC36>='Person Specification'!$AA$7,jobsApplicationdb!AE36>='Person Specification'!$AC$7,jobsApplicationdb!AG36>='Person Specification'!$AE$7,countif ($B$12:$B$109,B92)<1),jobsApplicationdb!C36,"")))))
At the end, i check for duplicates
countif ($B$12:$B$109,B92)<1),
Bookmarks