Hi,
I'm sorry if this is sounds totally basic, but wondering if you can help.
I am trying to create a sheet that will display a list of product if there is one or more required:
I have required quantities listed in Col I on the "Inventory"! sheet.
I then created another sheet and used
=+IF(Inventory!I6>=1,Inventory!I6,"")
to display that number if = or greater than 1.
This works fine. But when I copy this down the column to show more items, it is also pulling up all the rows where there is no number or value.
I'm sorry if this is not clearly described.
Is there a way that I can make it close up all the rows where there is no value? can anyone point me in the right direction or where I can find the answer?
Thanks in advance for any help you can provide me
Littlemt
I'm sorry if this is sounds totally basic, but wondering if you can help.
I am trying to create a sheet that will display a list of product if there is one or more required:
I have required quantities listed in Col I on the "Inventory"! sheet.
I then created another sheet and used
=+IF(Inventory!I6>=1,Inventory!I6,"")
to display that number if = or greater than 1.
This works fine. But when I copy this down the column to show more items, it is also pulling up all the rows where there is no number or value.
I'm sorry if this is not clearly described.
Is there a way that I can make it close up all the rows where there is no value? can anyone point me in the right direction or where I can find the answer?
Thanks in advance for any help you can provide me
Littlemt
