問(wèn)題已解決
老師,有的單元格中是兩個(gè)車(chē)牌號(hào),我想統(tǒng)計(jì)一共有多少車(chē)牌號(hào)呢,怎么統(tǒng)計(jì)?
![](https://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
![](/wenda/_nuxt/img/iconWarn.60bd4fe.jpg)
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
您好,數(shù)據(jù)透視表可以計(jì)算不重復(fù)的數(shù)量
2022 06/21 10:00
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
小林老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 06/21 10:00
您好,您這個(gè)需要拆分
![](http://member.chinaacc.com/homes/resources/images/home/avatar/6.jpg)
84784986 ![](/wenda/_nuxt/img/reply1.d92ea43.png)
![](/wenda/_nuxt/img/reply1.d92ea43.png)
2022 06/21 10:01
老師我要步驟
![](https://pic1.acc5.cn/011/91/71/85_avatar_middle.jpg?t=1651216838)
小林老師 ![](/wenda/_nuxt/img/reply2.28c7604.png)
![](/wenda/_nuxt/img/reply2.28c7604.png)
2022 06/21 10:06
您好,表格加一列,=int(len(對(duì)應(yīng)數(shù)據(jù))/7)
![](/wenda/img/newWd/sysp_btn_eye.png)