Match Formula to populate unique values in Range

[bishaldaddy]

Can someone help me on below formula, used to populate unique values from a Range "NAME", present in DEPT "Science"

MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0)


Complete Formula:
{=INDEX(NAME,MATCH(0,COUNTIF($B$<wbr>1:B1,NAME)+(DEPT<>"Science"),0))}


Note:

1. This formula is used in Range B1
2. NAME is the Range with many repeated names
3. DEPT is Range corresponding to Names with values as Science