Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Conditonal Comparison
Hi,
I am wondering what the best way to do a multiple conditional comparison is? For example I have 3 columns of data where I need the first column compared, then if TRUE, compare data in the second column which if also TRUE, then flag the result. P/N Class Qty 12345 A 3 12345 B 5 12345 C 2 54321 A 4 54321 C 1 So in the above data example, I need to essentially compare the class codes within the same part number and if the quantity of class "A" is less than "B" OR "C" (in situations where only one these class codes exist) then place a flag in "A's" row. However in situations where both class "B" AND "C" exist for the same part number, I need to flag "A" if it's quantity is less than the COMBINED quantity of "B" AND "C". Any help would be appreciated. I'm getting a headache trying to figure out the forumla. Thanks. Ella |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple column comparison on 2 worksheets | Excel Worksheet Functions | |||
Multiple Conditonal Formats | Excel Discussion (Misc queries) | |||
multiple comparison between means | New Users to Excel | |||
multiple comparison between means | New Users to Excel | |||
multiple comparison between means | New Users to Excel |