Spreadsheet: 787005d1657597653-rank-desired-number-of-large-value-without-duplicate-in-other-table-book15-ans5
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | rank top 30 mond (columns H) in data like below without duplicat
 | code | name | family | age | sex | cost |  |  |  |  | Pay attention to the sum value at the end of each H column, which should not be included in the function h38 h73 h91 and …
 |  |  |  |  |  | mond | now | some |  |  |  | Rank | name | family | age | sex | mond
 | 1200 | aaa | sqw | 22 | m | 546165367 | 0 | 0 |  | 30 | num rank
 | 1200 | ss | sqw | 2 | m | 756531 | 0 | 0 |  |  | sex | 1
 | 1200 | dd |  | 43 | m | 756531 | 0 | 0 |  |  | code | 2
 | 1200 | eee | d | 34 | m | 756531 | 0 | 0 |  |  |  | 3
 | 1200 | rrtt | family | 5 | f | 133247 | 0 | 0 |  |  |  | 4
 | 1200 |  | family | 5 | f | 19396882 | 320630420 | 595 |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | I have removed merged cells
 | 1200 | yy | e | 4 | f | 9544851 | 566086394 | 446 |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  | Not possible to use formulas in merged cells
 | 1200 |  |  | 55 | f | 546165367 | 0 | 0 |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  | Range B44:B70 changed for verification.
 | 1200 | aaa | sqw | 22 | m | 546165367 | 0 | 0 |  |  |  | 8
 | 1200 | ss | sqw | 2 | m | 104369 | 0 | 0 |  |  |  | 9
 | 1200 | dd |  | 43 | m | 16245323 | 0 | 0 |  |  |  | 10
 | 1200 | eee | d | 34 | m | 25658431 | 0 | 0 |  |  |  | 11
 | 1200 | rrtt | family | 5 | f | 13797800 | 2447330000 | 63 |  |  |  | 12
 | 1200 |  | family | 5 | f | 5531028 | 0 | 0 |  |  |  | 13
 | 1200 | yy | e | 4 | f | 19396882 | 125097610 | 32 |  |  |  | 14
 | 1200 |  |  | 55 | f | 29327424 | 55750000 | 125 |  |  |  | 15
 | 1200 | aaa | sqw | 22 | m | 18300609 | 615710000 | 506 |  |  |  | 16
 | 1200 | ss | sqw | 2 | m | 17654248 | 1150000 | 115 |  |  |  | 17
 | 1200 | dd |  | 43 | m | 10654016 | 0 | 0 |  |  |  | 18
 | 1200 | eee | d | 34 | m | 77248634 | 0 | 0 |  |  |  | 19
 | 1200 | rrtt | family | 5 | f | 39871310 | 0 | 0 |  |  |  | 20
 | 1200 |  | family | 5 | f | 39871310 | 0 | 0 |  |  |  | 21
 | 1200 | yy | e | 4 | f | 20201797 | 305080000 | 120 |  |  |  | 22
 | 1200 | aaa | sqw | 22 | m | 14474552 | 132960000 | 79 |  |  |  | 23
 | 1200 | ss | sqw | 2 | m | 14474552 | 18280000 | 8 |  |  |  | 24
 | 1200 | dd |  | 43 | m | 1255555251 | 7425900000 | 175 |  |  |  | 25
 | 1200 | eee | d | 34 | m | 77248634 | 1599500000 | 37 |  |  |  | 26
 | 1200 | rrtt | family | 5 | f | 163636914 | 2000000000 | 4 |  |  |  | 27
 | 1200 |  | family | 5 | f | 1568940448 | 654600000 | 39 |  |  |  | 28
 | 1200 | yy | e | 4 | f | 82716175 | 0 | 0 |  |  |  | 29
 | 1200 |  | family | 5 | f | 1255555251 | 22165050000 | 614 |  |  |  | 30
 | 1200 | yy | e | 4 |  | 170567464 | 87500000 | 14 |  |  |  | 31
 | 1200 |  | family | 5 |  | 64908877 | 300192500 | 120 |  |  |  | 32
 |  |  | sum |  |  | 7351684701 | 40533225984 | 3338 |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  |  |  |  |  | 36
 | code | name | family | age | sex | cost |  |  |  |  |  | 37
 |  |  |  |  |  | mond | now | some |  |  |  | 38
 | 1300 | aaa | sqw | 22 | m | 5650007 | 0 | 0 |  |  |  | 39
 | 1300 | ss | sqw | 2 | m | 3135206 | 229726794 | 1065 |  |  |  | 40
 | 1300 | dd |  | 43 | m | 5701362 | 37030000 | 10 |  |  |  | 41
 | 1300 | eee | d | 34 | m | 100821 | 1000000 | 1 |  |  |  | 42
 | 1300 | rrtt | family | 5 | f | 1284913 | 0 | 0 |  |  |  | 43
 | 1300 |  | family | 5 | f | 37063003 | 124700000 | 8 |  |  |  | 44
 | 1300 | yy | e | 4 | f | 303821393 | 28642000 | 22 |  |  |  | 45
 | 1300 |  |  | 55 | f | 303821393 | 415740000 | 261 |  |  |  | 46
 | 1300 | aaa | sqw | 22 | m | 320652116 | 78410000 | 20 |  |  |  | 47
 | 1300 | ss | sqw | 2 | m | 325153405 | 19360000 | 31 |  |  |  | 48
 | 1300 | dd |  | 43 | m | 75732551 | 123500000 | 62 |  |  |  | 49
 | 1300 | aaa | sqw | 22 | m | 3306831 | 147900000 | 10 |  |  |  | 50
 | 1300 | ss | sqw | 2 | m | 14284034 | 9350000 | 17 |  |  |  | 51
 | 1300 | dd |  | 43 | m | 0 | 0 | 0 |  |  |  | 52
 | 1300 | eee | d | 34 | m | 651898648725 | 1039590000 | 1051 |  |  |  | 53
 | 1300 | rrtt | family | 5 | f | 651898648725 | 370885992 | 7 |  |  |  | 54
 | 1300 | aaa | sqw | 22 | m | 651898648725 | 0 | 0 |  |  |  | 55
 | 1300 | ss | sqw | 2 | m | 651898648725 | 1456515000 | 1437 |  |  |  | 56
 | 1300 | dd |  | 43 | m | 651898648725 | 8400000 | 2 |  |  |  | 57
 | 1300 | eee | d | 34 | m | 651898648725 | 11134540000 | 283 |  |  |  | 58
 | 1300 | rrtt | family | 5 | f | 166420767 | 1093690000 | 1753 |  |  |  | 59
 | 1300 |  | family | 5 | f | 839551884 | 0 | 0 |  |  |  | 60
 | 1300 | yy | e | 4 | f | 662090549 | 0 | 0 |  |  |  | 61
 | 1300 |  |  | 55 | f | 69050923 | 0 | 0 |  |  |  | 62
 | 1300 | aaa | sqw | 22 | m | 110774826 | 0 | 0 |  |  |  | 63
 | 1300 | ss | sqw | 2 | m | 61871888 | 10000 | 1 |  |  |  | 64
 | 1300 | dd |  | 43 | m | 639147015 | 0 | 0 |  |  |  | 65
 |  |  | sum |  |  | 11748764750872 | 40181218976 | 22809 |  |  |  | 66
 |  |  |  |  |  |  |  |  |  |  |  | 67
 |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  | 69
 | code | name | family | age | sex | cost |  |  |  |  |  | 70
 |  |  |  |  |  | mond | now | some |  |  |  | 71
 | 1200 | aaa | sqw | 22 | m | 12154562 | 46190000 | 41 |  |  |  | 72
 | 1200 | ss | sqw | 2 | m | 15093930 | 5200000 | 1 |  |  |  | 73
 | 1200 | dd |  | 43 | m | 57686505 | 15000000 | 1 |  |  |  | 74
 | 1200 | eee | d | 34 | m | 41391681 | 200245000 | 116 |  |  |  | 75
 | 1200 | rrtt | family | 5 | f | 22966633 | 587571000 | 1397 |  |  |  | 76
 | 1200 | aaa | sqw | 22 | m | 138448 | 0 | 0 |  |  |  | 77
 | 1200 | ss | sqw | 2 | m | 143339167 | 0 | 0 |  |  |  | 78
 | 1200 | dd |  | 43 | m | 470662217 | 280000000 | 1 |  |  |  | 79
 | 1200 | eee | d | 34 | m | 181801 | 0 | 0 |  |  |  | 80
 | 1200 | rrtt | family | 5 | f | 1310386 | 0 | 0 |  |  |  | 81
 | 1200 |  | family | 5 | f | 173136127 | 401100000 | 63 |  |  |  | 82
 | 1200 | yy | e | 4 | f | 32731901 | 0 | 0 |  |  |  | 83
 | 1200 |  |  | 55 | f | 7683703 | 0 | 0 |  |  |  | 84
 | 1200 | aaa | sqw | 22 | m | 117727 | 0 | 0 |  |  |  | 85
 | 1200 | ss | sqw | 2 | m | 48270844 | 0 | 0 |  |  |  | 86
 | 1200 | dd |  | 43 | m | 108001396 | 0 | 0 |  |  |  | 87
 |  |  | sum |  |  | 15044093838 | 23974158282 | 11684 |  |  |  | 88