Chitraruveshar
New Member
Hi,
Would like to transpose from column into row but would like to display every 5th column in a row.
IDS-CS SD HELPDESK
IDS-CS FRONT OFFICE
IDS-CS INSURANCE
IDS-CS RETAIL BANKING & CARDS
IDS-CS SHARED SERVICES
IDS-CS WHOLESALE BANKING
This formula worked {=IFERROR(INDEX(SuppGrp[SuppGrp],MATCH(0,COUNTIF(Legend!$H$2:$H2,SuppGrp[SuppGrp])+(SuppGrp[SumGrp]<>Legend!$G$1),0)),"")} but I manually increase to dispaly the next value from MATCH(0,COUNTIF(Legend!$H$2:$H2 to MATCH(0,COUNTIF(Legend!$H$2:$H3.
Is there a way to increase automatically to display the next support group in every 5th column?
It would be really great, if anyone could solve this.
Regards
Would like to transpose from column into row but would like to display every 5th column in a row.
IDS-CS SD HELPDESK
IDS-CS FRONT OFFICE
IDS-CS INSURANCE
IDS-CS RETAIL BANKING & CARDS
IDS-CS SHARED SERVICES
IDS-CS WHOLESALE BANKING
This formula worked {=IFERROR(INDEX(SuppGrp[SuppGrp],MATCH(0,COUNTIF(Legend!$H$2:$H2,SuppGrp[SuppGrp])+(SuppGrp[SumGrp]<>Legend!$G$1),0)),"")} but I manually increase to dispaly the next value from MATCH(0,COUNTIF(Legend!$H$2:$H2 to MATCH(0,COUNTIF(Legend!$H$2:$H3.
Is there a way to increase automatically to display the next support group in every 5th column?
It would be really great, if anyone could solve this.
Regards