Question: I want a unique list to be created from a column where an adjacent column has text cell value?

Array formula in D3:

=INDEX(List, MATCH(0, COUNTIF(\$D\$1:D1, List)+(ISTEXT(\$B\$2:\$B\$17)=FALSE), 0))

How to create an array formula

1. Copy array formula (Ctrl + c)
2. Double click cell D2
3. Paste array formula (Ctrl + v)
4. Press and hold Ctrl + Shift
5. Press Enter

Named ranges
List
(A2:A17)
What is named ranges?

(Excel 97-2003 Workbook *.xls)

IF(logical_test;[value_if:true];[value_if_false])
Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

ROW(reference) returns the rownumber of a reference

MATCH(lookup_value;lookup_array; [match_type])
Returns the relative position of an item in an array that matches a specified value

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

ISTEXT(value)
Checks whether a value is text, and returns TRUE or FALSE

ISERROR(value)
Checks whether a value is an error and returns TRUE or FALSE

This blog article is one out of thirteen articles on the same subject "unique".

### Related posts:

Create unique distinct list from column where an adjacent column meets criteria

Create a list of distinct values from a list where an adjacent cell value meets a criteria in excel

Create and sort distinct list by adjacent cell value size

Filter unique distinct list sorted based on sum of adjacent values using array formula in excel

Create a unique distinct text list from a range containing both numerical and text values in excel