I using this formula to copy duplicates of column S (starting at S10) over to U (starting at U10) - =IF(COUNTIF($S$10:S10,S10)=1,S10,""). However, I want it to only apply to the filtered data meaning if a duplicate was found on S11 with S13 and the duplicate was moved to S11, the next time I...