Fill formula if column w is greater than 0(zero)

[HaroonSid]

hello
i m using below formula to get value in column b4 of column v if value is greater than 0 of column w

i m getting result after every 5 rows

e.g
i have data in range V4:V10 and i want to like value range v4:v10 with cells, b4,b9,b14,b19,b24( after every 5 rows) if column w4:w13 is greater than 0

i m getting the result as below
v4 = 1
w4 = 3 (greater than 0(zero))
then
b4 = 1 and b5:b8 is blank

i want also 1 in b5:b8

thanx

[benishiryo]

hi haroon. try this array formula in C4:
=IFERROR(INDEX($V$4:$V$13,SMALL(IF($W$4:$W$13>0,ROW($W$4:$W$13)),CEILING(ROWS(C$4:C4)/5,1))-ROW($W$4)+1),"")

[HaroonSid]

Hello benishiryo

worked fine thanx alot
will add u reputation