Need some help with a formula...thanks in advance
thanks Dom, perfect
"Domenic" wrote:
Try...
B3, copied down:
=INDEX(Record!D$1:D$100,SMALL(IF(Record!$A$1:$A$10 0=$B$1,ROW(Record!$A$1:
$A$100)-ROW(Record!$A$1)+1),ROWS(B$3:B3)+1))
....confirmed with CONTROL+SHIFT+ENTER. This will return the second
occurrence to B3, the third occurrence to B4, and so on.
Hope this helps!
In article ,
Jambruins wrote:
Domenic,
Acutally there is still a problem. If I put the formula you gave me into
cell B3 it does find the next occurance of 0-.4. However, I copied the
formula down but cell B4 gives me the same answer as cell B3. Should I be
using $ before and after the A and D in the formula? Should the +1, 2 change
when I copy it down? Thanks
|