I need an equation for Column B where every 22 products will give me a #1, 2, 3... (1= 22 products, 2- 44, etc). Also I need an equation for the remaining products taken out of the 22 product equations in Column C.
Please see attached.
I need an equation for Column B where every 22 products will give me a #1, 2, 3... (1= 22 products, 2- 44, etc). Also I need an equation for the remaining products taken out of the 22 product equations in Column C.
Please see attached.
Column B appears to have dates in it. I'm not entirley sure what it is you are looking for?
The dates are just the expected dates to have production ready by
it would be easier for us to help you if you showed an example of what you want, and how you arrived at your answer
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
All I need is an equation for every 2 products to show me that I have reached that point. Then it will conutinue on from the remaining products to the next 22 products...
try this...i used column E for this, so copy it there and move it wherever you need it to be
=IF(D3+E2>22,D3+E2-22,D3+E2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks