Data in tabs based on group number

[inayat]

Hi All,

I want to have the data to be seggregated in the tabs based on the group no. Attached is the sheet. Also is it necessary to have the Group No as the first column.

Thanks in advance.

Cheers-
Inayat

[Fotis1991]

Hi

In Group1 Sheet, in A3 put this ARRAY(C+SH+EN) formula and copy down and across.

Same for the others Sheets-Groups.

=IFERROR(INDEX(Master!A$3:A$10,SMALL(IF(Master!$A$3:$A$10=1,ROW(Master!$A$3:$A$10)-2),ROW(Master!A1))),"")

[inayat]

Thanks Fotis for your help. Not only did it resolve the problem but I finally understood it to apply to other problems like this.

And Yes even we are not proud of our politicians.

[Fotis1991]

You are welcome!

Glad to agree with me about politicians.

Thanks for the reb*