Forum Widgets
Latest Discussions
Degenerate MAP blows up Excel
Does this formula work for you? =MAP(0,1,LAMBDA(x,y,x+y)) Which Build are you on? I am stuck on 2406 because all Builds since blow up when running my spreadsheets - which, as I type this, JUST MIGHT be down to this nonsense. Not only does this innocent instruction return #VALUE!, it also appears to corrupt Excel beyond recovery. Which is a problem because the MAP(LAMBDA( phrase is a wrap one needs to deploy when a Lambda(a,b... might have to handle vectors for a and b to return a vector of results for a computation that will not support such vector inputs natively. The cure for this nonsense on my Build appears to be =MAP(HSTACK(0),HSTACK(1),LAMBDA(x,y,x+y)) Unfortunately, it is hard to remember this. I might have to scour my Lambdas. The problem only appears to concern MAPs with multiple vectors. =MAP(1,LAMBDA(x,x)) is just fine.ecovonreinFeb 09, 2025Iron Contributor27Views0likes1CommentFormula assistant
Hi All, Attached the following pic: Im trying to create the yellow cells by formula (I made it manually) the rules: if the column date and the raw date is a match so it should give us column H value (exm:cell J7, the column date is 01/01/2025, same as row 7 date so im getting H7 value) one cell to the right where we got our match I want it to take the left cell divide by minus 4 and multy by 3 (15360/4*-3 = -11520) and than to the next 3 cell to the right, I want to get the -11520/-3 = 3840 after 3 cells I want it to get zeroed, thx all in advanced !TomerIwanirFeb 09, 2025Occasional Reader34Views0likes3CommentsAI to work with Excel
Hello All, I have been trying to find an AI that can help be transform data in Excel. The specific task at hand is to transform data from a cash register into a csv that can be directly imported into a German accounting software named DATEV. It has some specific requirements concerning amounts (no thousand separator) and a date format that is a bit odd. So far, I just pivoted the sales transaction data into a table with 8 columns for each product category and copied them manually into a csv that can be imported with no problem. That takes about 20 minutes, checking for errors etc. Now I just spent 90 minutes explaining the task to ChatGPT, but it kept spitting out only nonsense, completely unusable. I could of course learn python pandas, but that would take a while. Does anyone know an AI that can translate a fairly simple format into another fairly simple format? Thanks.alexmeneikis_17111969Feb 09, 2025Copper Contributor14Views0likes1CommentThe Formatting got wrong!!!!!
Hey! Someeone please help me with this... I have few data sets with me and both of them have dates coloumn in it. So I wanted to syncronize the dates from one sheet to another so I copied both in one sheet. Since is a daily data of 3 years its difficult tally them as the formatting of one sheet was different. So I want to change the formatting same as sheet 1 but the formatting fuction changes only selective cells which does not make any sense. Follow the image below....28Views0likes1CommentFormula worked in Excel under windows10 but not in Windows 11
=SUMPRODUCT(((Urenregistratie!A2:A2500)=1)*(Urenregistratie!I2:I2500)) The Formula above worked in Excel under windows10 but not in Windows 11, did something change? How can I make my formula work again? Hope anyone can help me... Best regards, Rick.Rick_DijsFeb 09, 2025Copper Contributor19Views0likes2CommentsExcel Online Checkbox COUNTIF Issue – Checkbox State Resets Unexpectedly
Hi everyone, I'm experiencing an issue with checkboxes in Excel Online. I have a table where I use checkboxes (TRUE/FALSE) in five rows, and below them, I use the following formula to count how many checkboxes are checked: =COUNTIF(F1:F5,TRUE) However, when I check a box, the counter briefly updates (e.g., from 0 to 1 if only one box is checked) but then immediately resets back to 0 within a second, as if the checkbox is being unchecked in the background. This behavior does not occur in the offline (desktop) version of Excel, where everything works as expected. Additionally, after reloading the page, sometimes the checkboxes reset to an unchecked state, and other times the counter updates correctly. Is there a known issue with checkboxes in Excel Online, or is there a setting I might have misconfigured? Any advice would be greatly appreciated! Thanks in advance.SolvedMichalPavFeb 09, 2025Copper Contributor49Views0likes3CommentsIf you thought Spills killed CSE, read this post
I build financial models. All financial models I have ever seen do the same thing - they show one reporting date per column. Every next reporting period evolves from the previous financial close. That is, the calculation order in such models is strictly A1 to An, B1 to Bn, ... N1 to Nn. There may at times arise the need to perform complex calculations that produce more than one result. Today, we can (program those in Lambdas and) spill the outputs across multiple rows (within the same column). Alas, Excel's performance resizing Spills is absolutely atrocious. Deploy such a formula across the columns of your model and you can literally watch the pixels set. One column at a time. Things settle after the initial run. There is then no need to resize ever again. Just so long as the calculation works out alright. Unfortunately, stuff happenz. And when that calculation errors out, you are back to watching pixels set as Excel replaces your multiple result rows with one row of #VALUE!. Once you fix that error, well, then you are back in for another treat of umpteen resize passes... Such a spreadsheet is frankly unusable. Now, I noticed with some astonishment that there is a simple fix for this nonsense: Just enter your spill formula with Control-Shift-Enter to morph it into an array formula. Sure, we all hate those. But all the hassle around editing is a price worth paying for Excel suddenly attaining Warp speed... Post Scriptum: There is another "solution" to this problem. Instead of performing the calculation once to spill 5 results, perform the same calculation 5 times over and return 1 result each time. If you think this is awful, you are of course correct. But ... to my amazement, doing this easily beats the Spill (no surprise - even using an Abacus probably will) and there was no telling a difference to CSE. I was baffled. Then I realized what Excel got up to. Excel understands that these 5 calculations are independent of one another and will happily parallelize them across multiple CPU cores. So, while this insane solution hammers the CPU, the nature of a financial model is such that it mostly cannot exercise more than one core anyway (it cannot be multi-threaded), such that on the occasion that we are being stupid, there are plenty of cores idling around that can bail us out... :) Post Post Scriptum: If for some reason you do not wish to use CSE, make absolutely sure that when stuff happenz your Spill returns 5 bad results. That avoids Excel having to resize that range when an error occurs.ecovonreinFeb 09, 2025Iron Contributor46Views0likes2CommentsChange Default Browser in Which Hyperlinks Open
Moments ago for whatever reason, my Excel Home and Student 2021 began opening hyperlinks in Edge. I did not change this setting. How do I change the browser back to Google Chrome without editing the registry? If it makes any difference, I am using Windows 11.grasFeb 09, 2025Occasional Reader31Views0likes4Comments
Resources
Tags
- excel42,169 Topics
- Formulas and Functions24,444 Topics
- Macros and VBA6,347 Topics
- office 3655,930 Topics
- Excel on Mac2,615 Topics
- BI & Data Analysis2,328 Topics
- Excel for web1,877 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,606 Topics