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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

Watch MrExcel Video

Forum statistics

Threads
1,112,942
Messages
5,543,124
Members
410,583
Latest member
jgalin
Top