00:00Recently someone inquired, how can you count the number of occurrence of these numbers on this raw data here?
00:06Well, this is how I will do it. I have a prep column here.
00:09What prep column does is that it basically shifts out only the numbers and to do that use this formula.
00:14The sequence function technically builds an array so that you can store each character as one element in an array.
00:19The mid plus zero converts each of these array elements from string to a number by simply adding zero and the if error function
00:26watches over this conversion of string to a number process. If an array is encountered, it will return a blank.
00:30Otherwise, a number is returned. Concatenate function combines a numeric array into a single string and the value converts the single string into a number.
00:37Then after that, hit enter and apply the same formula to the rest of the row like this.
00:41And to count the number of occurrence, you're gonna say count if. The first argument will be the preparatory column itself.
00:47Gonna press F4 to make it fix, comma, the search text, close parentheses, and apply the same formula to the rest of the row like this.
00:54And you're done.
Comments