Array Formula On Excel For Mac
Answer : This doesn't seem to work in Mac Excel 2016. After a bit of digging, it looks like the key combination for entering the array formula has changed from ⌘ + RETURN to CTRL + SHIFT + RETURN . Select the range, press CONTROL + U and then press ⌘ + RETURN .