Hello,

I have an array formula which searches one input in a column of a named range, and ignores any blank entries:

[VBA]=IFERROR(INDEX(GrandTab,SMALL(IF(COUNTIF($C$3,INDEX(GrandTab,,1,1))>0,IF(IN DEX(GrandTab,,11,1)<>"",ROW(GrandTab)-MIN(ROW(GrandTab))+1)),ROW(A1)),11),"")[/VBA]

I made an array formula which would ignore duplicates (I think)

[VBA]=INDEX(GrandTab,MATCH(0,COUNTIF($C$4,GrandTab),0))[/VBA]

Is there a way to fit this (or a similar) function into my first, so that I have an array formula which both skips over blanks and duplicates?

These formulae are hurting my mind.

Thank you.