Understanding a formula I already have to extract duplicates

[mike4777]

I don't understand how to implement this formula:

IFERROR(INDEX($C$23:$C$265, MATCH(0, COUNTIF(N$23:$N23, $C$23:$C$265), 0),1),"")

I need to remove the duplicates in list C23:C265 and place the new entries in N23:N52


I've tried putting it in cell n23 and copying down but it doesn't produce anything. Thanks for any help!

 

[mike4777]

never mind, I figured it out. I wasn't treating it as an array formula.

 

[Aladin Akyurek]

You mean you want to extract a unique list of items from C23:C265 to N23 downwards, right?