Can't believe this fixed the problem so quickly, my version of excel said "er, sorry, no can do", got disappointed looked and thought "where's all the numbers gone, woohoo" lol genius solution, thanks very much
This is amazing. Looked on another blog post and they were suggesting a formula akin to producing your own version of Jarvis. My problem was that the column had 1,000 rows of data each prefaced with 1., 2., 3.,...11., 12.,...105., 106., etc. This removed the entire numerical sequence in 5 seconds.
I want to use the leftover letters and copy and paste them into another file to cross check with another set of data. Is won't let me copy the letters, it only pastes the formula. Any suggestions?
Hi there, thank you so much for such informative video. I have a request, please help me if you can. My data looks something like this - "3.50 Good Earth 3.75 Hail Sezer 4.33 Cottam Lane". Now using the Flash function I can separate the text and digits, however, what I want is each name set should go in each column. I tried doing - Good Earth in one column and used FlashFill it worked for few but in some cases it brought the digits too. The Flash fill is failing in those rows where there is no second word in the column; for e.g. if the row contained "3.50 Good Earth 3.75 Hail Sezer 4.33 Cottam Lane" and if I write Good Earth in next column it works fine for "1.67 Courageous Knight 6.00 Ezaj 8.00 Quinault" but if there was "3.25 Ebury 5.00 Antagonize 5.00 Truth In Jest", the answer of flash fill was "Ebury 5.00 Antagonize" I think if somehow I can tell Excel that these two are a "set", it will work, isn't it? Please guide
You could use the approach you talked about in your November 16, 2021, "Excel REDUCE Function - LAMBDA Array Formulas," to solve this problem. =LET( str,A1, arr, {0,1,2,3,4,5,6,7,8,9}, REDUCE(str,arr,LAMBDA(a,r,SUBSTITUTE(a,r,""))) )
@@ExcelGoogleSheets It's available to me even though I'm not an Office Insider. I've Office 365. There is one topic I haven't seen any talk about, specifically, LAMBDA functions can take a function as parameter, like a callback function. Perhaps you can do a video on that topic. For example, here is such a function: CallBack = LAMBDA(f, x, f(x)) If "Factorial(n)" is a factorial function of n, then CallBack(Factorial, 10) would yied 3,628,800. If "SumIntegers(n)" is function summing 1 to n, then CallBack(SumInteger, 10) would yield 55. But I can't think of a good use case for this very nice feature in Excel. Hope you can come up with some idea. For a Google Spreadsheets apologist, you make best tutorials on Excel Lambda and its helper functions.