演示数据(load sample data)
......
add F
(
按项目汇总合计金额textjoin开票日期唯一值:
满足条件合并单元格内容和满足条件单元格求和-Excel函数与公式-ExcelHome技术论坛) (
背景background
)
copy from Excel(video)
项目号 发票金额 开票日期 发票号 2001601 17920 2016/12/23 11875265 2001601 17920 2017/6/12 11875266 2001602 74750 2017/1/3 62180076 2001602 67275 2017/2/14 62180088 2001602 1839.44 2017/6/12 4211873 2001602 1969.64 2017/6/12 4211874 2001602 1901.99 2017/6/12 4211875 2001602 99840 2017/7/7 18639424 2001602 4266.6 2017/7/7 18639425 2001603 4200 2017/8/3 31185354 2001603 102000 2017/9/14 34481177 2001603 14242.8 2017/10/16 2436712 2001603 14012.35 2017/10/16 2436713 2001604 28528 2017/10/23 2436872 2001604 49920 2017/10/23 2436883 2001604 9000 2017/12/11 18050905 2001604 2746.14 2017/12/19 21852009 2001604 59883 2017/12/25 21852056 2001605 49920 2018/4/17 45671240 2001605 35971.63 2018/6/26 9169716 2001605 34133.57 2018/7/5 9169865 2001605 142000.08 2018/7/20 30273523 2001605 59124.99 2018/7/27 30273634 2001605 136000.02 2018/8/14 30555620 2001606 88500 2018/8/14 30555621 2001606 88500 2018/8/14 30555622 2001606 88500 2018/8/14 30555623 2001606 88500 2018/8/17 30555728 2001606 88500 2018/8/23 30555829 2001607 88500 2018/9/5 51896835 2001607 142000.08 2018/9/18 51897078 2001607 59124.99 2018/9/18 51897079 2001607 136000.02 2018/9/28 67746833 2001607 88500 2018/10/23 67764771 2001607 88500 2018/10/23 67764772 2001607 88500 2018/10/23 67764773