show me a result based on ID, SUM and NAME

[Hansulet]

I need a formula to show me results as follows:

For each ID, the formula must show me in column D the first name for which the sum>0 for the same ID.
If sums>0 and the name AFP are found for an ID, then in column D, for this ID, the result is AFP.

ID	SUM	NAME
111	0	AAA
222	200	BBB
333	300	CCC
111	100	DDD
222	0	CCC
333	0	AFP
333	400	AFP
ID	SUM	NAME	RESULT
111	0	AAA	DDD
222	200	BBB	BBB
333	300	CCC	AFP
111	100	DDD	DDD
222	0	CCC	BBB
333	0	AFP	AFP
333	400	AFP	AFP

 

[davesexcel]

Your results sample is based on equal values, not >0, is this what you are looking for?

 

[AOB]

Your example is contradictory to your problem description?

The "first" name for ID 333 for which SUM > 0 is CCC (row #3) not AFP (row#7)

Based purely on the description, and not the example result, this formula should do what you're looking for (but like I say, I get a different result for ID 333, based on your problem description)

=IFERROR(INDEX($A$2:$C$8,MATCH(1,($A$2:$A$8=$A2)*($B$2:$B$8>0),0),3),"")

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1	ID	SUM	NAME
2	111	0	AAA	DDD
3	222	200	BBB	BBB
4	333	300	CCC	AFP
5	111	100	DDD	DDD
6	222	0	CCC	BBB
7	333	0	AFP	AFP
8	333	400	AFP	AFP
Report

Cell Formulas
Range	Formula
D2:D8	D2	=INDEX(SORT(FILTER($B$2:$C$8,$A$2:$A$8=A2),1,-1),1,2)

 

[Hansulet]

How about

Fluff.xlsm
	A	B	C	D
1	ID	SUM	NAME
2	111	0	AAA	DDD
3	222	200	BBB	BBB
4	333	300	CCC	AFP
5	111	100	DDD	DDD
6	222	0	CCC	BBB
7	333	0	AFP	AFP
8	333	400	AFP	AFP
Report

Cell Formulas
Range	Formula
D2:D8	D2	=INDEX(SORT(FILTER($B$2:$C$8,$A$2:$A$8=A2),1,-1),1,2)

Thank you

 

[Hansulet]

Your example is contradictory to your problem description?

The "first" name for ID 333 for which SUM > 0 is CCC (row #3) not AFP (row#7)

Based purely on the description, and not the example result, this formula should do what you're looking for (but like I say, I get a different result for ID 333, based on your problem description)

=IFERROR(INDEX($A$2:$C$8,MATCH(1,($A$2:$A$8=$A2)*($B$2:$B$8>0),0),3),"")

In the case of SUM>0 and NAME is AFP, the result must give me AFP.

 

[Hansulet]

Your results sample is based on equal values, not >0, is this what you are looking for?

In the case of SUM>0 and NAME is AFP, the result must give me AFP.

 

[Hansulet]

How about

Fluff.xlsm
	A	B	C	D
1	ID	SUM	NAME
2	111	0	AAA	DDD
3	222	200	BBB	BBB
4	333	300	CCC	AFP
5	111	100	DDD	DDD
6	222	0	CCC	BBB
7	333	0	AFP	AFP
8	333	400	AFP	AFP
Report

Cell Formulas
Range	Formula
D2:D8	D2	=INDEX(SORT(FILTER($B$2:$C$8,$A$2:$A$8=A2),1,-1),1,2)

Thank you, but the formula is not checked if I expand the database with other IDs.
For example, for ID 555 in the attached example, the result is AAA, instead of AFP, as it should be.
I mention that an ID can have an unlimited number of occurrences.

ID	SUM	NAME	FORMULA	CORRECT RESULT
111	0	AAA	DDD	DDD
222	200	BBB	BBB	BBB
333	300	CCC	AFP	AFP
111	100	DDD	DDD	DDD
222	0	CCC	BBB	BBB
333	0	AFP	AFP	AFP
333	400	AFP	AFP	AFP
444	0	EEE	AFP	AFP
444	500	AFP	AFP	AFP
555	0	FFF	AAA	AFP
555	600	AAA	AAA	AFP
555	200	AFP	AAA	AFP

 

[AOB]

=IF(IFERROR(MATCH(1,($A$2:$A$8=$A2)*($B$2:$B$8>0)*($C$2:$C$8="AFP"),0),0)>0,"AFP",IFERROR(INDEX($A$2:$C$8,MATCH(1,($A$2:$A$8=$A2)*($B$2:$B$8>0),0),3),""))

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D
1	ID	SUM	NAME	FORMULA
2	111	0	AAA	DDD
3	222	200	BBB	BBB
4	333	300	CCC	AFP
5	111	100	DDD	DDD
6	222	0	CCC	BBB
7	333	0	AFP	AFP
8	333	400	AFP	AFP
9	444	0	EEE	AFP
10	444	500	AFP	AFP
11	555	0	FFF	AFP
12	555	600	AAA	AFP
13	555	200	AFP	AFP
14
Report

Cell Formulas
Range	Formula
D2:D13	D2	=LET(f,FILTER($B$2:$C$100,$A$2:$A$100=A2),IF(ISNUMBER(MATCH("AFP",INDEX(f,,2),0)),"AFP",INDEX(SORT(f,1,-1),1,2)))