在Excel中排序随机寄存器 [英] sort random register in excel

问题描述

我在excel中有12000多个寄存器，寄存器排序升序，我要随机排序
谢谢.

i have more than 12000 register in excel , the register sort ascending , i want sort random
thanks.

推荐答案

目前尚不清楚您的问题是什么.我假设您没有指定要保存在寄存器中的12,000个变量.您只问如何对12,000个变量向量进行随机排序吗?

相当于生成12,000个订单统计信息. James Gentle的书中有一种算法，可用于顺序生成订单统计信息.

以下是该书勘误的链接以及该书的名称.

http://mason.gmu.edu/~jgentle/books/rngbk/rng2errata.htm [ ^ ]

It''s not clear what your question is. I am assuming you are not specifying 12,000 variables to be held in registers. Are you only asking how to do a random sort on a 12,000 variable vector?

It''s equivalent to generating 12,000 order statistics. There is an algorithm in James Gentle''s book that you can use for sequential generation of order statistics.

Below is a link to the errata of the book along with the name of the book.

http://mason.gmu.edu/~jgentle/books/rngbk/rng2errata.htm[^]

这篇关于在Excel中排序随机寄存器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！