Single cell a1 has array entered as 1,4 7,9,16. I am using split function to transfer the numbers to an array. I want to validate the numbers are in the range
1-30 and also find the length of the array.