Forum Discussion
Generating Random Number, Excluding Cell in Next Calculation
I think IngeborgHawighorst will have used the RANK function to rank each instance of a random number within the list. This will generate values 1-46 that are used as the index (row number) parameter within the INDEX function.
I am puzzled by the "@" symbol that appears before the INDEX function in the formula bar (blocking an array calculation to return a single value). Who is it that is using an up-to-the-minute version of Office 365?
[Just checked back; it was Ingeborg's post that included the symbol]
PeterBartholomew1 Yes, I use Office Insider, which already includes the new Dynamic Array functions. It's sometimes hard to write functions the old way, because things now just work. The backwards compatibility is achieved with the @ symbol that tells a function not to use the new array way of things, so it is backwards compatible with older versions of Excel. It will show in the screenshot, but not if you open an Excel file.