Has anyone noticed that RANDARRY is the only dynamic array function that’s actually smuggled the word “array” into its name? My explanation for that curiosity isn’t likely to stir you with its profundity. My take is that Excel had to differentiate RANDARRY from its random-number-generating predecessors RAND and RANDBETWEEN, and ARRAY seems like a perfectly good and descriptive term to pair with RAND this time.
Yes, RANDARRY does generate dynamic arrays, and swiftly and easily, though its user-friendliness doesn’t address ...
