|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
如图所示,各位大神能不能教教我1、怎么挑选前十位编号相同的各“合计”项并求和;
2、形成新的列,显示各个编号是否存在后四位数>=2000的数据,有的话是1没有的是0
A1405260010600 | 水 | 300 | 0 | 0 | 0 | 0 | A1405260010600 | 合计 | | 0 | 0 | 0 | 0 | A1405260010850 | 咖啡 | 9.75 | 23.34 | 1.37 | 0.7 | 2.89 | A1405260010850 | 水 | 150 | 0 | 0 | 0 | 0 | A1405260010850 | 包子(猪肉) | 120 | 280.32 | 8.76 | 12 | 34.32 | A1405260010850 | 精盐 | 0.75 | 0 | 0 | 0 | 0 | A1405260010850 | 青油 | 0.75 | 6.75 | 0 | 0.75 | 0 | A1405260010850 | 合计 | | 310.42 | 10.13 | 13.45 | 37.21 | A1405260011150 | 凉面 | 100 | 167.7 | 4.8 | 1.7 | 33.3 | A1405260011150 | 精盐 | 1.5 | 0 | 0 | 0 | 0 | A1405260011150 | 青油 | 4 | 36 | 0 | 4 | 0 | A1405260011150 | 枇杷 | 90 | 37.98 | 0.72 | 0.18 | 8.37 | A1405260011150 | 西瓜 | 200 | 53 | 1.2 | 0.2 | 11.6 | A1405260011150 | 合计 | | 294.64 | 6.72 | 6.08 | 53.27 | A1405260011300 | 花生仁(生) | 12 | 70.2 | 2.98 | 5.32 | 2.6 | A1405260011300 | 水 | 300 | 0 | 0 | 0 | 0 | A1405260011300 | 合计 | | 70.16 | 2.98 | 5.32 | 2.6 | A1405260011600 | 水 | 200 | 0 | 0 | 0 | 0 | A1405260011600 | 枇杷 | 135 | 56.95 | 1.08 | 0.27 | 12.55 | A1405260011600 | 合计 | | 56.97 | 1.08 | 0.27 | 12.55 | A1405260011700 | 鸡蛋 | 25.5 | 36.6 | 3.09 | 2.68 | 0.03 | A1405260011700 | 大米 | 41.25 | 143.69 | 3.05 | 0.33 | 32.13 | A1405260011700 | 精盐 | 1.8 | 0 | 0 | 0 | 0 | A1405260011700 | 青油 | 4.5 | 40.5 | 0 | 4.5 | 0 | A1405260011700 | 合计 | | 220.72 | 6.14 | 7.51 | 32.16 | A1405260012000 | 鸡蛋 | 25.5 | 36.6 | 3.09 | 2.68 | 0.03 | A1405260012000 | 大米 | 41.25 | 143.69 | 3.05 | 0.33 | 32.13 | A1405260012000 | 花生仁(生) | 6 | 35.1 | 1.49 | 2.66 | 1.3 | A1405260012000 | 水 | 200 | 0 | 0 | 0 | 0 | A1405260012000 | 精盐 | 1.8 | 0 | 0 | 0 | 0 | A1405260012000 | 青油 | 4.5 | 40.5 | 0 | 4.5 | 0 | A1405260012000 | 合计 | | 255.8 | 7.63 | 10.17 | 33.46 | A1405260012100 | 枇杷 | 180 | 75.96 | 1.44 | 0.36 | 16.74 | A1405260012100 | 合计 | | 75.96 | 1.44 | 0.36 | 16.74 |
|
|