การประยุกต์ใช้เงื่อนไข
Posted: Fri Oct 26, 2018 12:12 pm
รบกวนอาจารย์หรือผู้ที่ทราบแนะนำด้วยครับ
แบบ textjoin D10 กด ctrl+shift+enter
=Textjoin(",",,IF(D2:L2>0,D$1:L$1&"="&D2:L2,""))
แบบอดทน
=SUBSTITUTE(TRIM(IF(D2,D$1&"="&D2&" ","")&IF(E2,E$1&"="&E2&" ","")&IF(F2,F$1&"="&F2&" ","")&IF(G2,G$1&"="&G2&" ","")&IF(H2,H$1&"="&H2&" ","")&IF(I2,I$1&"="&I2&" ","")&IF(J2,J$1&"="&J2&" ","")&IF(K2,K$1&"="&K2&" ","")&IF(L2,L$1&"="&L2&" ",""))," ",",")