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.
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.