Hello,

I have a formula working in Column AQ 
=IF(AP2="","",IF(COUNTIF(AP:AP,AP2)=1,AP2,""))
however the formula is not giving me the results I need. IF formula to remove duplicate values.PNG

What I want to do is run the same IF for duplicate values and it highlight return the value if the count is >1

so for example the $14,666.33 is duplicated 6 times in the AP column. I want the formula to capture just the one instance of the $14,666.33 and place that value in column AQ