formula to overwrite blank lines

[purpleozzie]

Hi,

I have the following formula..

=IFERROR(IF(ROWS($1:1)<=COUNTA('Pre-Packaged Beer'!A:A)*2,INDEX('Pre-Packaged Beer'!A:A,MOD(ROWS($1:1)-1,COUNTA('Pre-Packaged Beer'!A:A))+2),""), "")

Which cycles through a list of products twice...

Is there anyway of adding to this formula so that if the value in column 'Y' = 0 then to miss out that product.. However, I don't want blank lines..

for instance:

Column A Column Y
Product 1 £50.00
Product 2 £49.00
Product 3 £48.00
Product 1 0
Product 2 £85.00
Product 3 £83.00

Would equal:

Column A Column Y
Product 1 £50.00
Product 2 £49.00
Product 3 £48.00
Product 2 £85.00
Product 3 £83.00

I also don't want to use macro's

Cheers,