组合数的序列号（The serial number of the combination）.docVIP

组合数的序列号（The serial number of the combination） The following program is Excel VBA code The number (in ascending order, otherwise, must be sorted first) is converted to a serial number This function does not test the validity of the data. The input data must be meaningful when the amount of computation is large, the N is used as a private variable of the module or class, so that the initialization is not repeated when used. Public Function NumberToSerial (ByVal N As Long, ByVal M As Long, by ref Numbers () As Long) As Long When the amount of computation is large, CalTable () is used as a private