Filling a two dimentional Table based on the columns of other table

[mahhdy]

Hello,

I have a scheduling task, I am schedueling people in a table, after that I wanted to seperate each team working in each aircraft to be shown in a different table. So I have a two condition, Team and A/C. I tryed to use Index + Small function, but joining the conditions with AND will remove the array to a binary value. Not sure if Sumproduct(-- is usefull here or not.

Can anybody help?
This is my source table:
[TABLE="width: 757"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]NAME
[/TD]
[TD]POSITION[/TD]
[TD]A/C[/TD]
[TD]Team[/TD]
[/TR]
[TR]
[TD]*****,J***y
[/TD]
[TD]Aircraft Manager[/TD]
[TD]70006[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]M***o,John
[/TD]
[TD]Production Lead[/TD]
[TD]70008
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD]Vi***ty,Dh***j
[/TD]
[TD]Methods Agent[/TD]
[TD]70009
[/TD]
[TD]C
[/TD]
[/TR]
</tbody>[/TABLE]
Here is the destination table:

[TABLE="width: 515"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Team A
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]70006
[/TD]
[/TR]
[TR]
[TD]NAME
[/TD]
[TD]POSITION
[/TD]
[/TR]
[TR]
[TD]*****,*****
[/TD]
[TD]Aircraft Manager
[/TD]
[/TR]
[TR]
[TD]M*****o,J***
[/TD]
[TD]Production Lead[/TD]
[/TR]
[TR]
[TD]****,D****j
[/TD]
[TD]Methods Agent
[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 515"]
<tbody>[TR]
[TD="colspan: 2"]Team B
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]70006
[/TD]
[/TR]
[TR]
[TD]NAME
[/TD]
[TD]POSITION
[/TD]
[/TR]
[TR]
[TD]*****,*****
[/TD]
[TD]Aircraft Manager
[/TD]
[/TR]
[TR]
[TD]M*****o,J***
[/TD]
[TD]Production Lead[/TD]
[/TR]
[TR]
[TD]****,D****j
[/TD]
[TD]Methods Agent
[/TD]
[/TR]
</tbody>[/TABLE]

Thanks and Regards,
M

 

[mahhdy]

HI,

I find out, Instead of using and( condition1 ,condistion 2) I have to multiple them. if( condition 1* condition 2)....


Cheers,
M