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.
https://support.jetglobal.com/hc/en-us/community/posts/360027747193-Unpredictable-behavior-with-rand-function

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 
=NL("Random=NumberOfRandoms",other,filter,criteria)
but I actually think it works better as the extra command filter operator similar to "Limit".
=NL("rows","item","no.","random","10")

This can be used for acid testing from an accounting perspective, or for spot checking/cycle counting from an inventory perspective.