Complex formula Help / Multiple Criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-1928564%22%20slang%3D%22en-US%22%3EComplex%20formula%20Help%20%2F%20Multiple%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1928564%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%20again%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20rather%20complex%20sheet%20that%20I%20want%20to%20make%20automatic%20based%20off%20the%202%20yellow%20columns%20%22G%22%20%26amp%3B%20%22H%22.%20Inventory%20Report%20Tab%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-All%20notes%20are%20in%20the%20Excel%20file%20attached.%20I%20am%20relatively%20new%20to%20Excel%20formulas%20so%20I%20am%20having%20a%20rather%20hard%20time%20wrapping%20my%20head%20around%20how%20I%20could%20go%20about%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20let%20me%20know%20if%20anything%20does%20not%20make%20sense%20as%20I%20tried%20to%20explain%20everything%20I%20need%20a%20good%20as%20possible.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1928564%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-1929608%22%20slang%3D%22de-DE%22%3ESubject%3A%20Complex%20formula%20Help%20%2F%20Multiple%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1929608%22%20slang%3D%22de-DE%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%3EWith%20your%20permission%2C%20please%20describe%20your%20project%20step%20by%20step%20in%20this%20table.%20What%20exactly%20do%20you%20want%20to%20accomplish%3F%3CBR%20%2F%3ECall%20this%20sheet%20very%20complex%20yourself%2C%20do%20not%20expect%20others%20to%20understand%20this%20immediately.%20Maybe%20there%20are%20people%20here%20who%20are%20very%20familiar%20with%20excel%2C%20but%20this%20does%20not%20mean%20that%20they%20are%20also%20familiar%20with%20invetour%20or%20storage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20of%20this%20should%20not%20mean%20that%20I%20can%20offer%20you%20an%20answer%20...%3CBR%20%2F%3EIs%20just%20a%20recommendation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1929626%22%20slang%3D%22de-DE%22%3ESubject%3A%20Complex%20formula%20Help%20%2F%20Multiple%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1929626%22%20slang%3D%22de-DE%22%3EIt%20is%20also%20helpful%20to%20know%20the%20operating%20system%20and%20Excel%20version%2C%20as%20different%20approaches%2Fformulas%20may%20be%20required%20depending%20on%20the%20version%20and%20OS.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1931174%22%20slang%3D%22en-US%22%3EBetreff%3A%20Complex%20formula%20Help%20%2F%20Multiple%20Criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1931174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%20Hi%20Nikolino%2C%20I%20apologize%20for%20the%20confusion.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Operating%20System%20-%20Microsoft%20Windows%2010%20Pro.%3C%2FP%3E%3CP%3E2.%20I%20am%20using%20the%20version%20of%20excel%20that%20exist%20in%20Microsoft%20365.%20I%20am%20not%20sure%20the%20exact%20version%20this%20compares%20to.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi everyone again,

 

I have a rather complex sheet that I want to make automatic based off the 2 yellow columns "G" & "H". Inventory Report Tab

 

-All notes are in the Excel file attached. I am relatively new to Excel formulas so I am having a rather hard time wrapping my head around how I could go about this.

 

Please let me know if anything does not make sense as I tried to explain everything I need a good as possible.

6 Replies

@T-Meyers 

With your permission, please describe your project step by step in this table. What exactly do you want to accomplish?
Call this sheet very complex yourself, do not expect others to understand this immediately. Maybe there are people here who are very familiar with excel, but this does not mean that they are also familiar with invetour or storage.

 

All of this should not mean that I can offer you an answer ...
Is just a recommendation.

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

It is also helpful to know the operating system and Excel version, as different approaches/formulas may be required depending on the version and OS.

@Nikolino  Hi Nikolino, I apologize for the confusion. 

 

1. Operating System - Microsoft Windows 10 Pro.

2. I am using the version of excel that exist in Microsoft 365. I am not sure the exact version this compares to.

 

@Nikolino Hi Again,

 

Project Step by Step:

 

1. I receive a report of garments that I need to reorder each week.

 

2. Each Garment has its own "SKU"

-Style

-Color

-Size

-Quality

-Quantity

 

3. On the "Inventory Report Sheet" I plug the report I receive into the "Yellow Columns".

 

4. The columns on this same sheet to the left of the yellow columns break the SKUs down so I can filter more specifically.

 

5. Columns "I" through "M" convert the quantity that is needed to be reordered into case pack or boxed quantities. The companies we order from only ship full case/box quantities.

 

6. Usually I would break the Inventory Report Sheet down into the 3 order forms that are also in this excel file.

 

Referring to:

-Brand

-Style

-Color

-Size

-Quantity

 

7. I want to make Step#6 automatic. Every formula would have to refer to the Brand Column (Column "A") of "Inventory Report" Sheet. This is due to each reorder form being specifically 1 brand.

 

8. Each reorder form template that the company needs is in somewhat of a different format. Therefore each set of formulas per sheet would need to be different.

 

 

-My end goal is to only have to paste in the report(Yellow Columns), I receive weekly and end up with 3 reorder forms auto filled with the correct quantities needed without having to manually fill in every every garment quantity.

 

-I hope this helps understand what I am trying to do a little bit more.

 

 

 

 

@T-Meyers 

Made some columns as I understood the translation.
(It's not your English, it's the translation and my humble knowledge of English, to put it mildly).

 

If this is the way I set it in the file, then you can continue from there.

Please don't ask me to do this for you, I don't do commissioned work.
Do all of this on a voluntary basis, helping and being helped is my motto.

 

Wish you have a nice day.

 

Thank you for your understanding and patience

 

Nikolino

 

I know I don't know anything (Socrates)

@Nikolino 

 

Hi again,

 

I am not sure which columns you actually added? And some formulas do not make sense to me. Also I am not asking you specifically to do all of this for me. I was just posting into the community in hopes of help from multiple people (Different Ideas). As I am not very familiar with complex formulas and have not had any luck finding an answer when searching online.

 

Sorry for the confusion and also for the accidental statements towards you when I asked questions.