How to create a list from a dropdown depending on the list with x values?-CodePudding

Home > Enterprise > How to create a list from a dropdown depending on the list with x values?

How to create a list from a dropdown depending on the list with x values?

Time：12-20

For example, in the image below, I have a dropdown from a-j, and I want to return a list, if I selected "a" from the drop down, the list will return (q,w,r,t,y)

enter image description here

=FILTER(Sheet1!$C$2:$X$2,Sheet1!$C$4:$X$26="x","")

CodePudding user response：

Use nested FILTER() function like-

=FILTER(B1:G1,FILTER(B2:G11,A2:A11=J1)="x")

Page link：https//www.codepudding.com/Enterprise/648373.html

Prev:Excel VBA Run time error 6 when assigning value to cell

Next:sed: replace newline within <p> </p> with space

Tags：

excelexcel-formula

Links：
CodePudding