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 this, I want if id (eg 1111) has all apporved in next corresponding cell than in column c it will show approved for all id( 1111), if all not approved in any cell than it show not approved for all id 1111 in column c. same for all id's.
thanks in advance
Regards
[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 this, I want if id (eg 1111) has all apporved in next corresponding cell than in column c it will show approved for all id( 1111), if all not approved in any cell than it show not approved for all id 1111 in column c. same for all id's.
thanks in advance
Regards