remove duplicates based on IF formula

Hello,

I have a formula working in Column AQ

Please Login or Register  to view this content.

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

.=COUNTIF(AP:AP,AP18)-1 is working but now I need to use an =AP for the unique values(that's easy enough). But then I also want in column AR the first duplicate record and not the rest.

so i example below, just need the first $8037.76 value in column AR and not the 6 duplicates. I want to be able to put both these formulas in AR1 and drag down based on count if I used above.

SUMIFS .=COUNTIF(AP:AP,AP18)-1
8,037.76 6.00
8,037.76 6.00
8,037.76 6.00
8,037.76 6.00
8,037.76 6.00
8,037.76 6.00
8,037.76 6.00

I want to just have the Unique values from column AP places into Column AR, so -AP(1) then drag that formula down that will capture all the uniques.

then, just take the first duplicate value in column AP. So if the count if returns 6 duplicate values, have a formula in column AR just bring in that first duplicate value and not the other 6. Having those return a blank in that cell in column AR.

this is where I am stuck. What kind of logic do I write on the false statement to only bring me the first duplicate value in AP and not the rest.

Capture.PNG

this formula is working somewhat

Please Login or Register  to view this content.