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
[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