Hi Excel Experts!
Basically, I have items with ID's. Example:
ITEM ID Extended Cost
If you notice, the first 3 numbers in the item ID is what we use for our categories (100, 200, 300, and 400).
I need a formula that will take the first 3 numbers of the item id and add the extended cost into one final output such as:
100 = 58
200 = 30
300 = 68
400 = 80
I have attached an example of what our actual document looks like when we export it from our software. If someone can help me with this excel formula I can then write the applescript that our user has to run that would automate this.
Note: I am running Microsoft Office 2008 and 2011 (which supports Macros). I am on a MAC.
I plan on creating an applescript.app that would automate this. But if someone could make this into a excel macro that would work for Office 2011 then AWESOME!
Otherwise, I will be fine with just the formula; and write the script myself. I just suck at excel formulas. Thanks experts.