Hi Tony...my Mac is down at the moment but my research indicates this...

Select the range, press CONTROL + U and then press ⌘ + RETURN . 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 .