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
May 24, 2024Bronze 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_MaxJul 26, 2024Iron ContributorThanks for the alternative; however, after an update (unsure which one), Excel has stopped crashing for this formula