Forum Discussion
Lauren565
Aug 09, 2022Copper Contributor
Function Help
I’m trying to count some data. The column I’m trying to count has a lot of different data. EX columns: xxxx_yyyy_zzz:3, xxxx_yyyy_uuu (has 1 value) ssss_www_iiii:2, ssss_www_ppp:1 (has 2 v...
Lauren565
Aug 10, 2022Copper Contributor
Harun24HR I’m having no problem counting the colons, I’m trying to count the once’s without the colons
Harun24HR
Aug 10, 2022Bronze Contributor
Can you put a screenshot of your excel and show what result you want? For first line you have one word that doesn't have colon but second line your both word has colon. So, what would be your output from these two line?