PDA

View Full Version : Array formula which ignores blanks and duplicates



jetimmins
10-27-2011, 02:38 AM
Hello,

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

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

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

=INDEX(GrandTab,MATCH(0,COUNTIF($C$4,GrandTab),0))

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.