R
rockyboxboa
I have a spreadsheet with the following values. Column A is the item number
and column B is the qty.
TAB1
A B
1 Item Number Qty
2 500cc 0
3 1500cc 100
4 1500sp 0
5 3000cc 100
6 16000cc 100
These figures are pulled out of the database when you enter the purchase
order. On another tab of the spreadsheet is the packing list. I need a
formula that will reference the previous worksheet and ignore the 0 values.
So I need the packing list to look like this:
TAB2
A B
1 Item Number Qty
2 1500cc 100
3 3000cc 100
4 16000cc 100
5
6
Now I have been using the following formula in cell A2 that reads:
=if(tab1!B2>0,tab1!A2,if(tab1!B3>0,tab1!A3,if(tab1B4>0,tab1!A4,if(tab1!B5>0,tab1!A5,if(tab1!B6>0,tab1!A6,"")
Now this formula works great for cell A2 on tab 2. The problem arises for
cell A3. If I do the same formula as above, I come up with the same answer as
cell A2. I need to have the same formula AND somehow exclude the result from
cell A2.
In cell A4, I need to have the same formula and exclude the result from cell
A2 and A3.
And so on and so forth.
Anybody have any ideas how I could do this?
and column B is the qty.
TAB1
A B
1 Item Number Qty
2 500cc 0
3 1500cc 100
4 1500sp 0
5 3000cc 100
6 16000cc 100
These figures are pulled out of the database when you enter the purchase
order. On another tab of the spreadsheet is the packing list. I need a
formula that will reference the previous worksheet and ignore the 0 values.
So I need the packing list to look like this:
TAB2
A B
1 Item Number Qty
2 1500cc 100
3 3000cc 100
4 16000cc 100
5
6
Now I have been using the following formula in cell A2 that reads:
=if(tab1!B2>0,tab1!A2,if(tab1!B3>0,tab1!A3,if(tab1B4>0,tab1!A4,if(tab1!B5>0,tab1!A5,if(tab1!B6>0,tab1!A6,"")
Now this formula works great for cell A2 on tab 2. The problem arises for
cell A3. If I do the same formula as above, I come up with the same answer as
cell A2. I need to have the same formula AND somehow exclude the result from
cell A2.
In cell A4, I need to have the same formula and exclude the result from cell
A2 and A3.
And so on and so forth.
Anybody have any ideas how I could do this?