Hi,
I just discoverd the power of matrix formula's and I wanna try how far this platform goes with it.
I am able to make a sum under conditions with use of the following formula:
{=SUM(((Table1[Weldtype]=$AU50)+(Table1[Weldtype]=$AU49)+(Table1[Weldtype]=$AU48))*Table1[Weldlength])}
AND
(ctr+shift+enter)
This formula (above) allows to give me (in ONE CELL) a sum of all the weldlengths were Weldtype is PP and FW.
See pic below for excel DATA.
Knipsel.PNG
My next goal is trying to generate IN ONE CELL a list of welders under the condition that Weldtype is PP AND FW.
So the formule must generate me:
"AB, GH, IJ, MN, OP, QR, UV, YZ, AZ, DW"
Does anyone has an idea if this is possible?
Bookmarks