Disappearing Data when duplicating text

MCB123x

New Member
Joined
Jun 29, 2020
Messages
30
Office Version
  1. 2007
Platform
  1. Windows
Hello,

I'm using this formula =IFERROR(INDEX(JN,MATCH(0,COUNTIF(JN,"<"&JN)-SUM(COUNTIF(JN,C$7:C9)),0)),"") which pulls a list from a column and puts it in another column, however as soon as I enter a duplicate name/word, it disappears from the list and leaves a blank cell. If this is repeated other names drop off from the pulled list. IDK what is happening.

Any help will do. Thank you.
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,114,644
Messages
5,549,154
Members
410,902
Latest member
G Slim
Top