bishaldaddy
New Member
- Joined
- May 17, 2017
- Messages
- 1
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:
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:
- This formula is used in Range B1
- NAME is the Range with many repeated names
- DEPT is Range corresponding to Names with values as Science
