|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
请问如何用名称管理器来做一个条件筛选并命名啊?
如:当B列大于0时把所有对应D 列的值命名为C 列的对应值:
如:02300119 等于 220090024-60 和 220090024-70
02402017 等于 220090024-52 和 220090024-56
A | B | C | D | 6 | 0 | 02233399 | 220090024-60 | 14 | 6 | 02233399 | 220090024-63 | 8 | 0 | 02233400 | 220090024-60 | 13 | 7 | 02233400 | 220090024-63 | 6 | 0 | 02300118 | 220PFP19703PC1 | 6 | 1 | 02300119 | 220090024-60 | 10 | 1 | 02300119 | 220090024-70 | 0 | 200 | 02311704 | 220090024-28 | 0 | 50 | 02311704 | 220PFT19318BB1 | 0 | 100 | 02351757 | 220090024-5 | 0 | 300 | 02351757 | 220090024-7 | 0 | 30 | 0235A05Q | 220090024-60 | 0 | 31 | 0235A05Q | 220090024-62 | 0 | 3 | 02402017 | 220090024-52 | 0 | 3 | 02402017 | 220090024-56 | 0 | 5 | 02402053 | 220090024-56 | 0 | 3 | 02402108 | 220090024-56 | 0 | 10 | 02402336 | 220090024-56 | 9 | 4 | 02402338 | 220090024-56 | 5 | 0 | 02402386 | 220090024-56 | 2 | 0 | 02402539 | 220090024-55 | 100 | 0 | 02402539 | 220090024-66 |
|
|