SOLVED

Difficult Formula Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-1785310%22%20slang%3D%22en-US%22%3EDifficult%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1785310%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20in%20need%20of%20some%20help%20with%20the%20sheet%20attached.%20All%20of%20my%20questions%20are%20on%20the%202%20tabs%20on%20my%20sheet.%20I%20am%20still%20learning%20the%20basics%20of%20excel%20so%20any%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20explain%20the%20things%20I%20am%20trying%20to%20do%20in%20the%20sheet%20as%20much%20as%20possible%2C%20so%20if%20anything%20doesn't%20make%20sense%2C%20I%20am%20more%20then%20willing%20to%20answer%20any%20questions%20about%20them.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1785310%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1788467%22%20slang%3D%22en-US%22%3ERe%3A%20Difficult%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1788467%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572655%22%20target%3D%22_blank%22%3E%40T-Meyers%3C%2FA%3E%2C%3C%2FP%3E%3CP%3ETake%20a%20look%20at%20this.%20I%20think%20there's%20more%20work%20to%20be%20done%20but%20it's%20a%20start.%3C%2FP%3E%3CP%3EIn%20sheet%20%22reorder%20insert%22%20column%20K%20and%20L%20are%20essentially%20the%20same.%20Or%20I%20missed%20something%20in%20your%20explanations.%3C%2FP%3E%3CP%3EI%20took%20the%20liberty%20to%20add%20a%20conditional%20formatting%20in%20sheet%20%22Break%20down%22%20so%20you%20can%20quickly%20spot%20your%20numbers%20in%20the%20grid.%3C%2FP%3E%3CP%3EI%20added%20a%20few%20examples%20for%20testing%2C%20take%20a%20look%20and%20let%20me%20know%20if%20you%20need%20any%20fine%20tuning.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1789328%22%20slang%3D%22en-US%22%3ERe%3A%20Difficult%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1789328%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3B%20I%20really%20appreciate%20your%20time%20helping%20me%20with%20this.%20I%20updated%20the%20same%20file%20with%20some%20questions%20highlighted%20in%20YELLOW.%20Some%20formulas%20were%20not%20working%20with%20come%20cells.%20As%20well%20I%20need%20some%20additional%20formulas%20if%20you%20know%20any%20that%20can%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20attached%20again%20when%20you%20have%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20again.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1790550%22%20slang%3D%22en-US%22%3ERe%3A%20Difficult%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1790550%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F572655%22%20target%3D%22_blank%22%3E%40T-Meyers%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20get%20a%20free%20case%20of%20T-shirt%20when%20I'm%20done%20with%20this%3F%20lol!%3C%2FP%3E%3CP%3ELook%20at%20the%20attached.%20I%20fixed%20the%20issues%20you%20were%20having%20on%20the%20first%203%20tabs.%3C%2FP%3E%3CP%3EFor%20the%20last%20two%20tabs%2C%20I%20need%20to%20put%20a%20bit%20more%20thinking.%20If%20I%20got%20it%20right%2C%20you%20want%20a%20summary%20for%20Gildan%20only%20and%20another%20one%20for%20US%20apparel%20only.%20Correct%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1799801%22%20slang%3D%22en-US%22%3ERe%3A%20Difficult%20Formula%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1799801%22%20slang%3D%22en-US%22%3ECorrect%2C%20I%20will%20be%20adding%20more%20brands%20to%20the%20list%20but%20if%20i%20have%20a%20template%20formula%20i%20can%20just%20copy%20it.%20Again%20I%20really%20do%20appreciate%20your%20help.%20Its%20hard%20to%20teach%20myself%20and%20work%20through%20my.%20Cant%20learn%20at%20home%20without%20excel%20as%20well.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all,

 

I am in need of some help with the sheet attached. All of my questions are on the 2 tabs on my sheet. I am still learning the basics of excel so any help would be greatly appreciated.

 

I tried to explain the things I am trying to do in the sheet as much as possible, so if anything doesn't make sense, I am more then willing to answer any questions about them.

5 Replies
Best Response confirmed by T-Meyers (Occasional Contributor)
Solution

Hi @T-Meyers,

Take a look at this. I think there's more work to be done but it's a start.

In sheet "reorder insert" column K and L are essentially the same. Or I missed something in your explanations.

I took the liberty to add a conditional formatting in sheet "Break down" so you can quickly spot your numbers in the grid.

I added a few examples for testing, take a look and let me know if you need any fine tuning.

 

@Bennadeau  I really appreciate your time helping me with this. I updated the same file with some questions highlighted in YELLOW. Some formulas were not working with come cells. As well I need some additional formulas if you know any that can help.

 

Please see attached again when you have time.

 

Thank you again. 

@T-Meyers 

Can I get a free case of T-shirt when I'm done with this? lol!

Look at the attached. I fixed the issues you were having on the first 3 tabs.

For the last two tabs, I need to put a bit more thinking. If I got it right, you want a summary for Gildan only and another one for US apparel only. Correct? 

Correct, I will be adding more brands to the list but if i have a template formula i can just copy it. Again I really do appreciate your help. Its hard to teach myself and work through my. Cant learn at home without excel as well.

@T-Meyers 

Take a look at this updated version.

In Sheet "US apparel Reorder Sheet" I made some modifications. All you need to do is input every possible codes (this will take time, I hope you have a list already) in column "A" (e.g. BLT0519-1-WCRL-S) and the remaining cells (style, description, color, grade and size) will fill out automatically. Then, if that code has an order quantity associated to it, it will add it at the end. I assumed you wanted to know how many cases needed to be order for each code but you can easily change that for the number of actual T-shirt will be ordered.

If that suits your needs, you can use that sheet as a template for any brand you add.