I want to count how many list in the cell. I have a table like this
And I don’t know how to count that list so it can make out put like this
I’m sorry I’m not using the table to ask in here because I don’t know how to use list on the table. You can Access the sheet here : sheet2
Thanks!
>Solution :
try:
=INDEX(LEN(REGEXREPLACE(A2:A4, "[^\.]", )))


