It should work in xl2010 too. Did you confirm the formula with the CTRL and Shift keys and then Enter.