Hello,
I am trying to create a unique values column (V) that looks to data source column (S), that will pull out unique values that only contain "key text" without repeats. So far I have the formula that will analyse the entire data source column and will create a list of unique values. This formula is as follows:
{=IFERROR(INDEX($S$3:$S$500,MATCH(0,INDEX(COUNTIF($V$2:V2,$S$3:$S$500),0,0),0)), "")}
Any idea how to make it so it will only add values that contain "MET/" and/or "XDCR/" to the unique values column?
Bookmarks