Forum Discussion
BA_Max
May 24, 2024Iron Contributor
Figuring out Excel Crash reason
Hi I've posted a similar thing on the answers.microsoft but realised I couldn't upload a spreadsheet example. My issue is that a specific formula seems to be causing a crash that didn't prior...
dscheikey
Bronze Contributor
Hi!
I can offer you an alternative formula. I can't say what is causing your crash. I only use Excel for the web.
=FILTER(F4:F21,ISNUMBER(XMATCH(G4:G21,B13:B17)))
BA_Max
Jul 26, 2024Iron Contributor
Thanks for the alternative; however, after an update (unsure which one), Excel has stopped crashing for this formula