Multiple Criteria

[gajender]

Hi,

[TABLE="width: 302"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]STATUS[/TD]
[TD]Confirmed Status[/TD]
[/TR]
[TR]
[TD]3333[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4444[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2222[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3333[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2222[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3333[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1111[/TD]
[TD]Not Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4444[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1111[/TD]
[TD]Not Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3333[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3333[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3333[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1111[/TD]
[TD]Not Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4444[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1111[/TD]
[TD]Not Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1111[/TD]
[TD]Not Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3333[/TD]
[TD]Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]1111[/TD]
[TD]Not Approved[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]4444[/TD]
[TD]Approved[/TD]
[TD]




[/TD]
[/TR]
</tbody>[/TABLE]
I have data like above, So If id (eg 1111) have approved in next column cell, then it show approved for all id (eg 1111), if one of them or more than one is not approved then it show Not approved in column c which is confirmed status. thanks in advance.

Regards
Gajender

 

[Fluff]

How about

Excel 2013/2016
	A	B	C
1	ID	STATUS	Confirmed Status
2	3333	Approved	Approved
3	4444	Approved	Approved
4	2222	Approved	Approved
5	3333	Approved	Approved
6	2222	Approved	Approved
7	3333	Approved	Approved
8	1111	Not Approved	not approved
9	4444	Approved	Approved
10	1111	Not Approved	not approved
11	3333	Approved	Approved
12	3333	Approved	Approved
13	3333	Approved	Approved
14	1111	Not Approved	not approved
15	4444	Approved	Approved
Sheet1

Cell Formulas
Range	Formula
C2	=IF(COUNTIFS($A$2:$A$20,A2,$B$2:$B$20,"Not approved")>0,"not approved","Approved")