bundle

Hi I would like to know if it's possible to have a formula that says If column C has "&" then add the values of the respective colors from column B to column D. So basically if I did it manually, it would look something like in column D. It has to dynamic in a way that no matter how many "&" a...

Thank you for all of your topics. I skimmed over "some" of them looking for an answer for this sheet. I can and do have a sheet where I can make the formulas work using basic skills. ie...(B6*12*$E$3)+(C6*$E$3)+D6 to give me the break-down of the desired sum. I want to do it in reverse of this...

In part of an ongoing larger project that a team member is helping me with, this will help me get one step closer, I've tried using =RIGHT(B3),LEN - N but due to the nature of the "Titles" in column B3 being different # of characters to the right, I thought there but be a more direct and simpler...

Hi everyone, Can anyone help with this one please? I've got a list of items orders, the columns include the revenue from each item, the order number, and its unique product reference number. In this first piece of work, i have a list of 634 products ordered, that list is made up of 533 unique...

Hi!I have 5 workbooks, each workbook contains multiple worksheets and different header.Worksheets Name:1. Bundle Input2. Rebundle3. Sales4. Warehouse Transfer5. OthersIn 5 workbooks, I input all bundles in and out everyday of every month. The difference of Sales workbook was, it has a column...