找出表格是否有重复数据:
=IF(AND(G20=G19,D20=D19),"是","否")
筛选移除【重复的数据】然后开始统计
=SUBTOTAL(9,E2:E287)
找出表格是否有重复数据:
=IF(AND(G20=G19,D20=D19),"是","否")
筛选移除【重复的数据】然后开始统计
=SUBTOTAL(9,E2:E287)
转:https://www.cnblogs.com/LuoEast/p/10284090.html