Qualifying condition in to result

[sachin483]

i need the qualifying condition in to result for evaluating division & level in which condition they have qualified

data						result
DIV	DESG	LEVEL CODE	ACH	GROWTH		ACH	GROWTH
AA	LEVEL1	AA6	120	486269		103	260000​
AA	LEVEL1	AA7	113	203648		110	160000​
AA	LEVEL1	AA8	113	202773		110	160000​
AA	LEVEL1	AA10	117	237402		105	210000​
AA	LEVEL1	AA15	106	242482		105	210000​
AA	LEVEL1	AA16	106	242482		105	210000​
AA	LEVEL1	AA17	132	583812		103	260000​
AA	LEVEL1	AA18	120	101000		120	120000​
BB	LEVEL1	AA20	120	327859
BB	LEVEL1	AA22	105	247383
BB	LEVEL1	AA26	116	359719
BB	LEVEL1	AA27	116	359719
BB	LEVEL1	AA33	109	221556
BB	LEVEL1	AA34	109	657002
grid
DIVISION	DESG	ACH	growth
AA	LEVEL1	120	120000
AA	LEVEL1	115	140000
AA	LEVEL1	110	160000
AA	LEVEL1	105	210000
AA	LEVEL1	103	260000
BB	LEVEL1	120	90000
BB	LEVEL1	115	110000
BB	LEVEL1	110	130000
BB	LEVEL1	105	180000
BB	LEVEL1	103	230000

 

[RoryA]

A reminder:

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Qualifying condition in to result

i need the qualifying condition in to result for evaluating division & level in which condition they have qualified The same has been posted on another forum but due to no response i have posted here https://www.mrexcel.com/board/threads/qualifying-condition-in-to-result.1223015/

chandoo.org

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[sachin483]

The same has been posted on another forum
Qualifying condition in to result

 

[sachin483]

i want to evaluate level's on based of 5 qualifying criteria and plot the qualifying criteria next to it, if not eligible than "No"