Copy Value If Cell Value is Greater than 0.

[Teblol]

Hi All,

I am trying to create a formula to copy an item number into column F if the cell in column D is greater than 0. The item numbers will be listed in A1:A1000. The formula should search column D, and copy the item number found in that row to the next blank cell in column F. The attachment has the results I am looking for.

HELP EXAMPLE.xlsm

Thanks for taking the time to help with this formula.

[Ace_XL]

In F2

=IF(ROWS(A$1:A1)>COUNTIF($D$3:$D$11,">"&0),"",INDEX($A$3:$A$11,SMALL(INDEX(($D$3:$D$11>0)*(ROW($D$3:$D$11)-ROW($D$3)+1),),COUNTIF($D$3:$D$11,"<="&0)+ROWS(A$1:A1))))

Copy down as far as needed

[Teblol]

Thanks Ace_XL. With a little tweaking it worked perfectly for my report. There could be as many as 1000 items listed so I just had to change the numbers to 1000.