All public logs
Combined display of all available logs of 清冽之泉. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
- 09:54, 29 September 2025 Mwroot talk contribs created page 怎么在 MSO Excel XLOOKUP 中使用通配符 (Created page with "Excel 中结合 XLOOKUP 与通配符,将产生强大的生产力。以下讲讲在 XLOOKUP 中使用通配符的关键: <code>=XLOOKUP(<font style="color: blue">"*"&C3</font>,$A$2:$A$51,$D$2:$D$51,"没找着",2,1)</code> 诀窍在于用双引号把通配符引起来,用 & 把通配符与单元格连起来,第五个参数匹配模式选 2。 <pre> 通配符: * 任意个数的任意字符 ? 单个字符 ~ 用于转义 </pre> Category: MicroSoft Office")