A friend shared this challenge: extract the largest number from this text as420lkjs09nsdk2324lkjsd099 ! The answer is 2324. How do we solve this? Formulas? VBA? Continue reading
Largest Number Inside Alphanumeric String
Posts Tagged → array
Video 00044 Array Formulas_Example2_EXACT LEFT_functions
Question: Why use an array formula?
Answer: You can answer a complex question using only 1 array.
In this video, the array uses the EXACT and LEFT worksheet functions. Continue reading
Video 00043 Formulas_Array Formulas_Example1_LEN_function
Question: Why use an array formula?
Answer: Because you can answer many complex questions using only 1 array formula!
In this video, I use an array formula to extend the use of Excel’s LEN function. Continue reading