issuing numbers to values

[Guest]

i need some help with creating a list of numbers to use as reference numbers

i have 4 columns, the first is the quantity of the item to be made, second is the work order number(the value i want generated), third is the description and the last is the quantity made. i have a list of 200 items and only about 120 or so each week are made each week, but i need to show all items. it starts at where the last number left of and it needs to run consecutivly but not showing numbers in between. i have this formula so far if you can modify it to not show the result in the cel

=IF(A2>0,B2+1,IF(A2<=0,B2))

 

[Bernie Deitrick]

Mike,

Try

=IF(A2>0,B2+1,"")

HTH,
Bernie
MS Excel MVP

i need some help with creating a list of numbers to use as reference numbers.

i have 4 columns, the first is the quantity of the item to be made,

second is the work order number(the value i want generated), third is the
description and the last is the quantity made. i have a list of 200 items
and only about 120 or so each week are made each week, but i need to show
all items. it starts at where the last number left of and it needs to run
consecutivly but not showing numbers in between. i have this formula so far
if you can modify it to not show the result in the cell