Thanks. I tried all of that, but I am getting #N/A in both D3 and E. It seemed like D3 should have been Arange in stead of Brange so I tried that also with the same result.
Indeed, the formula in D3 should refer to Arange.
The formula you posted at my request:
=IF(ROWS(E$3:E3)<=$D$3,INDEX('DARTS offers'!B:B,SMALL(IF('DARTS offers'!A:A=$B$3,ROW('DARTS offers'!B:B)-MIN(ROW('DARTS offers'!B:B))+1),ROWS(E$3:E3))),"")
tells me the following.
1. You have data in DARTS offers in column A and B.
2. You have a destination sheet for the results you want to see.
3. B3 of the destination sheet houses a condition/criterion that must hold for column A of DARTS offers.
4. D3 of the destination sheet houses a COUNTIF formula.
5. The above quoted formula in control+shift+entered in E3 of the destination sheet and copied down.
6. You stated at my request that column A of DARTS offers is numeric.
We have defined dynamic name ranges using the foregoing, which adjust automatically whenever DARTS offers changes.
The formula
=COUNTIF(Arange,B3)
implemented in D3, along with the formula using dynamic name ranges:
=IF(ROWS(E$3:E3)<=$D$3,INDEX(Brange,SMALL(IF(Arange=$B$3,ROW(Brange)-ROW(INDEX(Brange,1,1))+1),ROWS(E$3:E3))),"")
implemented in E3 (using control+shift+enter) of DARTS offers, should deliver exactly the same results as the formula with whole column references you already tried out.