Microsoft@Doug Jenkins suggests Single() may not work on prior versions. That is correct. There is also small business owners who purchase based on need, and a 365 worksheet will not function in a cross platform shared environment where Concatenate ("&"), Indirect() and Cell() are used for extreme vector variable positioning of non-table "dynamic" lookup, not dynamic arrays. And, is further complicated by the presence of Implicit Intersection ("@") and curly braces ("{ }") in versions that return #Name, and #Ref, respectively. This is especially troublesome for older platforms using VBA resulting in abnormal termination of code - even with "On Error" error checking, or, for Office 365 emulated on the Mac, with its non-MS keyboard arrangement and unaccounted Sandbox programming. There needs to be a patch of some kind.
