Formula to get unique and alphabetically sorted list after matching a criteria

Hi All,

Please help me to correct this formula,

I just want to get unique and alphabetically sorted list after matching a criteria,

for Eex:

Campus Immediate Supervisor as per Workday
Campus2 Sheerish Madipadaga
Campus2 Ramesh Bandaru
Campus5 Kalyan Gorti
Campus2 Balachandar Manoharan
Campus5 Prashant Kamal
Campus2 Sridhar G
Campus2 Nisha Shine
Campus2 Nikunj Goel

The result will be like,

Campus2

Balachandar Manoharan
Nikunj Goel
Nisha Shine
Ramesh Bandaru
Sheerish Madipadaga
Sridhar G

Formula:
in "C2"
{=INDEX($B$2:$B$9,MATCH(0,COUNTIF($B$2:$B$9,"<"&$B$2:$B$9)-SUM(COUNTIF($B$2:$B$9,C$1:C1))+IF(Data!$A$2:$A$9<>"Campus2",1,0),0))}

Campus 5

Kalyan Gorti
Prashant Kamal

Formula:
in "D2"
{=INDEX($B$2:$B$9,MATCH(0,COUNTIF($B$2:$B$9,"<"&$B$2:$B$9)-SUM(COUNTIF($B$2:$B$9,D$1:D1))+IF(Data!$A$2:$A$9<>"Campus5",1,0),0))}


Thanks & Regards,
Saranya

Hi Boopathiraja,

I didnt know about the options that will allow us to upload excel files. So, I just typed in the blog itself. I ll use the features in future.

Thank u for the details u have provided.

Thanks & Regards,
Saranya

Hi Tony Valko,

Thank u for the speedy answer.

It helps me greatly.

Thanks,
Saranya