Question: How do I create a unique distinct list where adjacent cell values contains a search string?
Search string: 1
Unique distinct list
Filter unique distinct values where adjacent cells contain search string
Array formula in C12:
copied down as far as needed.
What is named ranges?
How to implement array formula to your workbook
Change the named ranges. If your list starts at, for example, F3. Change $C$11:C11 to F2:$F$2, in the above formulas.
Download excel file for this tutorial.
Filter unique distinct values where adjacent cells contain a search string.xls
(Excel 97-2003 Workbook *.xls)
Functions in this article:
Counts the number of cells within a range that meet the given condition
MATCH(lookup_value;lookup_array; [match_type] Returns the relative position of an item in an array that matches a specified value
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range
SEARCH() Returns the number of the character at which a specific character or text string is first found, reading left to right (not case sensitive)