I was trying to answer this StackOverflow question and stumbled on a way to consistently crash Excel. Here’s the formula that did it
=SUM(TRANSPOSE(OFFSET(Sheet2!B1,IF(ISNA(MATCH(($A$2:$A$6=A2)*($B$2:$B$6),Sheet2!$A$2:$A$6,FALSE)),0,MATCH(($A$2:$A$6=A2)*($B$2:$B$6),Sheet2!$A$2:$A$6,FALSE)),0)))
If I remove the TRANSPOSE function, no problemo. But as soon as I type it in, boom. The idea is to perform a two stage lookup in a single array [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2011/04/04/how-to-make-excel-crash/
Posted
Apr 04 2011, 07:30 AM
by
Daily Dose of Excel