ecalid
04-05-2023, 08:33 AM
Hello again guys,
I hope you are all well.
I'm struggling with this piece of code, I can't seem to find wildcards within lists, only exact values.
I need to return all the values located in C with the specific value, in this case "Extrusion", located in D. However, the cell might contain such lines as "Extrusion, Lamination, Mixing"
When I add the wildcard *, it wont work. Is there another way of doing this?
=IFERROR(INDEX($C$2:$C$500,AGGREGATE(15,6,(1/($B$2:$B$500="Extrusion"))*ROW($C$2:$C$500)-ROW($A$2)+1,ROW(A2))),"")
Many thanks,
I hope you are all well.
I'm struggling with this piece of code, I can't seem to find wildcards within lists, only exact values.
I need to return all the values located in C with the specific value, in this case "Extrusion", located in D. However, the cell might contain such lines as "Extrusion, Lamination, Mixing"
When I add the wildcard *, it wont work. Is there another way of doing this?
=IFERROR(INDEX($C$2:$C$500,AGGREGATE(15,6,(1/($B$2:$B$500="Extrusion"))*ROW($C$2:$C$500)-ROW($A$2)+1,ROW(A2))),"")
Many thanks,