Forum Discussion
Solved
Search for one value in column A and list all belonging values from column B
Hi, I have an excel sheet with 3 columns. In column A there are categories, in column B there are the different devices from each category. In column C I want to list all diveces depending of a co...
Hi Detlev,
brilliant :-) Hav emany thanks. For my examble this is the perfect working formula:
=WENNFEHLER(INDEX(L:L;AGGREGAT(15;6;ZEILE($K$3:$K$300)/($K$3:$K$300=$H$4);ZEILEN(K$3:K16)));"")
This was my first question in such a community and it worked perfect. Your answers were very quick and they led to the goal. Have a nice weekend. Greetings Andreas
Alternatively you can wrap IFERROR() around your formula.
Hi Detlev,
brilliant :-) Hav emany thanks. For my examble this is the perfect working formula:
=WENNFEHLER(INDEX(L:L;AGGREGAT(15;6;ZEILE($K$3:$K$300)/($K$3:$K$300=$H$4);ZEILEN(K$3:K16)));"")This was my first question in such a community and it worked perfect. Your answers were very quick and they led to the goal. Have a nice weekend. Greetings Andreas
Thanks, Andreas. You're welcome.
If you prefer German speaking/writing support then there are several communities/forums you can join.