目前,我正在使用下面的内容来检索数据验证的值,问题是当我将其设置为Source时,我得到了The list source must be a delimited list, or a reference to a single row or column. --如何使它作为数据验证源使用?
=TRIM(LEFT(SUBSTITUTE(MID(INDEX($B:$B,MATCH($A3,$A:$A,0)),FIND("|",SUBSTITUTE(INDEX($B:$B,MATCH($A3,$A:$A,0)),",","|",1))+1, LEN(I