Return list of all values that match criteria to one or more cells-CodePudding

Home > Back-end > Return list of all values that match criteria to one or more cells

Return list of all values that match criteria to one or more cells

Time：10-26

i to pick all zip codes(A:A) by city(C) and county (D)

I need to look like

is that posible? i need to remove all duplicates and get all zip codes for every county

CodePudding user response：

You'd want TEXTJOIN() and FILTER(), where the 2nd parameter of FILTER() holds a boolean structure:

=TEXTJOIN(" ",FILTER(A$2:A$30,(C$2:C$30=B2)*(D$2:D$30=C2)))