Understanding a formula I already have to extract duplicates

mike4777

Board Regular
Joined
Apr 12, 2011
Messages
119
I don't understand how to implement this formula:
Code:
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!
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

mike4777

Board Regular
Joined
Apr 12, 2011
Messages
119
never mind, I figured it out. I wasn't treating it as an array formula.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
You mean you want to extract a unique list of items from C23:C265 to N23 downwards, right?
 

Watch MrExcel Video

Forum statistics

Threads
1,114,252
Messages
5,546,758
Members
410,757
Latest member
jonni
Top