It is an array formula so when entering you must hold down Ctrl and Shift before pressing Enter (instead of just Enter). If you do it correct Excel will automatically put braces around the formula. Don't try to enter these manually. When you have entered one array formula correct you can copy it to other cells the normal way. If you edit an array formula you must again hold down Ctrl and Shift before pressing Enter.
|