#Num error in Array
Hi!
There's nothing wrong with your formula.
Are you sure the 4th occurrence is a match?
What does this return:
=COUNTIF(GCData!AN$1:AN$5,1)
The 4th instance may be a TEXT value?
Biff
"Ben Dummar" wrote in message
...
Hello,
I have the following array in the first cell. The array works great on
rows
1-3:
=INDEX(GCData!AM:AM,SMALL(IF(GCData!AN$1:AN$5=1,RO W($1:$5)),ROW(1:1)))
when it reaches the 4th occurences it gives the #num error, below is the
code in the 4th cell or row.
=INDEX(GCData!AM:AM,SMALL(IF(GCData!AN$1:AN$5=1,RO W($1:$5)),ROW(4:4)))
What can I do to fix the array?
|