00:00In my last few videos, I showcased five different ways to sum numbers that are separated by comma
00:04on a single cell. But someone had requested if I can do another video to find max and minimum
00:08numbers among the comma separated value. The answer to that is pretty straightforward.
00:13To determine the maximum value, you utilize the text split function to split the content of the
00:17cell B2 using a comma as a delimiter and storing the split values into an array. Subsequently,
00:23we employ the unary operator which is denoted by two dash to convert the array of elements
00:27into pure numeric value. Finally, we utilize the max function to identify the highest value within
00:33an array. To obtain the minimum value, simply duplicate the formula and replace the max with
00:38min. With this newly acquired knowledge, you can also do the same thing for average, standard deviation,
00:44and count.
Comments