'Count number of occurrences of People Chip in google sheet
Does google sheet support counting of People Chips? If not, is there an easy way to convert all the personal chips in a sheet to strings?
Solution 1:[1]
in some scenarios, you can use ISEMAIL like:
=SUMPRODUCT(ISEMAIL(A1:A10))
tho it's worth mentioning, that it does not differentiate between regular email in cell and people chips
and too convert chips into strings you can use TO_TEXT
=INDEX(TO_TEXT(A1:A10))
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | player0 |

