Re: [算表] 試算表做品項編碼問題

作者: windknife18 (windknife18)   2024-02-10 16:24:57
A6
=if(C6="","",xlookup(C6,$C$1:$E$1,$C$2:$E$2,,0)&countif($C$6:C6,C6))
往下複製
作者: hurahuraman (TEBinwe)   2024-02-10 18:33:00
太神了! 感謝大大幫助.
作者: windknife18 (windknife18)   2024-02-10 19:11:00
不客氣 :)

Links booklink

Contact Us: admin [ a t ] ucptt.com