Dears,
i need to limited the below formula and make it working automatically when i increase the column the row increasing after divided it
i used the below formula
=INDEX('[TESTSHeet.xlsx]Customers INFO'!$B$2:$B$201,ROWS('[TESTSHeet.xlsx]Customers INFO'!$B$2:I2)+(COLUMNS('[TESTSHeet.xlsx]Customers INFO'!$B$2:I2)-1)*'Agents INFO'!$E$1)
[TABLE="width: 102"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]Ahmed [/TD]
[/TR]
[TR]
[TD]Hany[/TD]
[/TR]
[TR]
[TD]4[/TD]
[/TR]
[TR]
[TD]Ali[/TD]
[/TR]
[TR]
[TD]6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[/TR]
[TR]
[TD]8[/TD]
[/TR]
[TR]
[TD]9[/TD]
[/TR]
[TR]
[TD]10
[TABLE="width: 1014"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]OS50200[/TD]
[TD]OS50201[/TD]
[TD]OS50202[/TD]
[TD]OS50203[/TD]
[TD]OS50204[/TD]
[TD]OS50205[/TD]
[TD]OS50206[/TD]
[TD]OS50207[/TD]
[TD]OS50208[/TD]
[TD]OS50209[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Ahmed [/TD]
[TD]Hany[/TD]
[TD]4[/TD]
[TD]Ali[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
i need to limited the below formula and make it working automatically when i increase the column the row increasing after divided it
i used the below formula
=INDEX('[TESTSHeet.xlsx]Customers INFO'!$B$2:$B$201,ROWS('[TESTSHeet.xlsx]Customers INFO'!$B$2:I2)+(COLUMNS('[TESTSHeet.xlsx]Customers INFO'!$B$2:I2)-1)*'Agents INFO'!$E$1)
[TABLE="width: 102"]
<colgroup><col></colgroup><tbody>[TR]
[TD]1[/TD]
[/TR]
[TR]
[TD]Ahmed [/TD]
[/TR]
[TR]
[TD]Hany[/TD]
[/TR]
[TR]
[TD]4[/TD]
[/TR]
[TR]
[TD]Ali[/TD]
[/TR]
[TR]
[TD]6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[/TR]
[TR]
[TD]8[/TD]
[/TR]
[TR]
[TD]9[/TD]
[/TR]
[TR]
[TD]10
[TABLE="width: 1014"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]OS50200[/TD]
[TD]OS50201[/TD]
[TD]OS50202[/TD]
[TD]OS50203[/TD]
[TD]OS50204[/TD]
[TD]OS50205[/TD]
[TD]OS50206[/TD]
[TD]OS50207[/TD]
[TD]OS50208[/TD]
[TD]OS50209[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Ahmed [/TD]
[TD]Hany[/TD]
[TD]4[/TD]
[TD]Ali[/TD]
[TD]6[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]9[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]