回複：thanks, but that is a series of random number

The method can handle random number collection. One column for the data, one column for max (same number for different row), one column for difference, one cell for MIN and using MATCH command to find what you want to locate.