rank desired number of large value without duplicate in other table

[kar2rost]

Hello, I have tried different ways but I could not solve this problem
I have searched a lot on the internet, but it still didn't work
I ask my friends to solve this for me
I want to find the top example 30 items without duplicate data from column H and insert them into the table shown
The desired number is entered in the yellow cell
The only important point here is that at the end of each column there is an H number that should not be included in the calculations
h38 h71 h93 and etc.


Thanks

Book15.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
2												rank top 30 mond (columns H) in data like below without duplicat
3	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 …
4							mond	now	some					name		family	age	sex	mond
5	1200						546165367	0	0		30	num rank
6	1200						756531	0	0				1
7	1200						756531	0	0				2
8	1200						756531	0	0				3
9	1200						133247	0	0				4
10	1200						19396882	320630420	595				5
11	1200						9544851	566086394	446				6
12	1200						546165367	0	0				7
13	1200						546165367	0	0				8
14	1200						104369	0	0				9
15	1200						16245323	0	0				10
16	1200						25658431	0	0				11
17	1200						13797800	2447330000	63				12
18	1200						5531028	0	0				13
19	1200						19396882	125097610	32				14
20	1200						29327424	55750000	125				15
21	1200						18300609	615710000	506				16
22	1200						17654248	1150000	115				17
23	1200						10654016	0	0				18
24	1200						77248634	0	0				19
25	1200						39871310	0	0				20
26	1200						39871310	0	0				21
27	1200						20201797	305080000	120				22
28	1200						14474552	132960000	79				23
29	1200						14474552	18280000	8				24
30	1200						1255555251	7425900000	175				25
31	1200						77248634	1599500000	37				26
32	1200						163636914	2000000000	4				27
33	1200						1568940448	654600000	39				28
34	1200						82716175	0	0				29
35	1200						1255555251	22165050000	614				30
36	1200						170567464	87500000	14
37	1200						64908877	300192500	120
38			sum				7351684701	40533225984	3338
39
40
41
42	code	name		family	age	sex	cost
43							mond	now	some
44	1200						5650007	0	0
45	1200						3135206	229726794	1065
46	1200						5701362	37030000	10
47	1200						100821	1000000	1
48	1200						1284913	0	0
49	1200						37063003	124700000	8
50	1200						303821393	28642000	22
51	1200						303821393	415740000	261
52	1200						320652116	78410000	20
53	1200						325153405	19360000	31
54	1200						75732551	123500000	62
55	1200						3306831	147900000	10
56	1200						14284034	9350000	17
57	1200						0	0	0
58	1200						651898648725	1039590000	1051
59	1200						651898648725	370885992	7
60	1200						651898648725	0	0
61	1200						651898648725	1456515000	1437
62	1200						651898648725	8400000	2
63	1200						651898648725	11134540000	283
64	1200						166420767	1093690000	1753
65	1200						839551884	0	0
66	1200						662090549	0	0
67	1200						69050923	0	0
68	1200						110774826	0	0
69	1200						61871888	10000	1
70	1200						639147015	0	0
71			sum				11748764750872	40181218976	22809
72
73
74
75	code	name		family	age	sex	cost
76							mond	now	some
77	1200						12154562	46190000	41
78	1200						15093930	5200000	1
79	1200						57686505	15000000	1
80	1200						41391681	200245000	116
81	1200						22966633	587571000	1397
82	1200						138448	0	0
83	1200						143339167	0	0
84	1200						470662217	280000000	1
85	1200						181801	0	0
86	1200						1310386	0	0
87	1200						173136127	401100000	63
88	1200						32731901	0	0
89	1200						7683703	0	0
90	1200						117727	0	0
91	1200						48270844	0	0
92	1200						108001396	0	0
93			sum				15044093838	23974158282	11684
Sheet1

 

[Fluff]

This is the 2nd time you have failed to mention cross-posting. Please make sure you do in future.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: rank desired number of large value without duplicate in other table
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[kar2rost]

Thank you for your notice
I thought these two sites were separate
And because it was necessary for me, I tried to follow up from two places
In any case, I apologize
Please help if you know what to do

 

[kar2rost]

Everyone says Cross posted at.....
But no one helps here and there
If any of my friends know how to solve this problem
Thankful

 

[Peter_SSs]

Everyone says Cross posted at.....
But no one helps here and there

Perhaps you didn't read post #2 very carefully or do what was asked in that post including ..

Be sure to follow & read the link at the end of the rule too!

If you have posted the question at more places, please provide links to those as well.

People here are very willing to help - if you follow the rules and do what is asked of you.

So, the first things you should do now are
- follow and read the link at the end of the rule you were directed to. Then you will know why all forums have rules about cross-posting and what they expect you to do.
- provide links to all places where you have posted the same question.