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

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

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,192
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,109,501
Messages
5,529,234
Members
409,857
Latest member
KailuaTown
Top