Listng team-wise names from a list

The formula in post 2, assumed that line 3 already has the title IPL-A...
It seems that you want the formula for line 2 (the title) and line 3 downwards...
I3, then copy accross:

=IFERROR(INDEX($F$2:$F$17,MATCH(0,INDEX(COUNTIF($H$3:H3,$F$2:$F$17),),0)),"")

I4, drag down and accross

=IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($F$2:$F$17)/($F$2:$F$17=I$3),ROWS($1:1))),"")

Originally Posted by jsridhar

@bebo021999 Thank you. It works. Just one suggestion. In the Title Row, it lists IPL-D, IPL-C, IPL-B and IPL-A. Instead, if it lists from IPL-A to IPL-D, it would look better. Otherwise, it is fine. Thank you.

If you want to sort the header rows, there are several ways to do it depending on your data:
1- If your data is relatively stable, and the team list is fixed:
Method 1: Copy I3:L3, paste it transposed into another column, for example, N3:N6. Sort this range, and then copy-paste transpose it back into I3:L3.
Method 2: Sort column F. Then copy/paste the values in the header range I3:L3. Revert to sorting by column A.

2- If your data frequently changes, and the team list is regularly updated:
Method 1: Use an auxiliary column, like column G, to mark column F according to A-Z conditions. (like sample attached)
Method 2: In my opinion, the best approach is to use VBA. (will come back if you refer to VBA)