index match array formula - replace cell references with ranges

I have been using this small example file to try to find a solution to a duplicates problem in a larger workbook.

when I use this formula

{=IF(LEN(D3),INDEX($B$7:$B$999,SMALL(IF($A$7:$A$999=D3,ROW($1:$993)),COUNTIF(D$3:D3,D3))),"")}

the desired result is found

but when I try to substitute the defined ranges with a named range

{=IF(LEN(D3),INDEX(NAME,SMALL(IF(CHARGE2=D3,ROW($1:$993)),COUNTIF(D$3:D3,D3))),"")}

I get random information

the actual formula I am trying to adapt to name each duplicate value name is

=INDEX(NAME,MATCH(LARGE(CHARGE2,1),CHARGE2,0),1)

any help appreciated. sample attached

In your second formula ROW($1:$993) makes a problem.

Define for instance MYROWS as:

Formula:

Please Login or Register  to view this content.

and then array formula in E3:

Formula:

Please Login or Register  to view this content.

shall work as expected.

PS. I'm not sure about the idea behind your last formula. may be there was something else in mind, because LARGE(CHARGE2,1) is the same as MAX(CHARGE2)

Formula:

Please Login or Register  to view this content.

Regards, TMS

Here's another one...

=IF(LEN(D3),INDEX(NAME,SMALL(IF(CHARGE2=D3,ROW(CHARGE2)-MIN(ROW(CHARGE2))+1),COUNTIF(D$3:D3,D3))),"")

Still array entered.

You're welcome.