colors Posted May 14, 2012 Share Posted May 14, 2012 Hello, I have about 50 blocks and each contain manuf. nos. The Data Extraction program is utilized which links these blocks to an excel spreadsheet to extract desc. & unit. to extract this data and placed in a bill of material together with the correct quantity calculated by this template. I have approximately 10 typical manuf. nos. that exist in various blocks. For example, manuf. No. "A123" will be in block "A", "G" and "M". The total quantity of this particular manuf no. is correctly calculated and placed in the bill of material. However, these manuf. no’s. quantity needs to be further divided by a “y” amount, and in the end needs to be rounded to the nearest 1 and placed on the quantity column. Can you please let me know which Table formula will work to achieve this result? Thank you. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.