There is an issue when trying to use any of the random functions that excel provides.
Please review the long debug trip I went on just recently and posted to the community forums.
My suggestion is for a type of random function to be built that will accept query criteria, and then randomly select "x" number of records to be displayed. This could be a separate function like
but I actually think it works better as the extra command filter operator similar to "Limit".
This can be used for acid testing from an accounting perspective, or for spot checking/cycle counting from an inventory perspective.