Distribute values in excel based on weight Inversely

[mojtabapordel]

We have 28 lecturers, each of whom has several units of study during the semester.
At the end of the semester, to take care of the exams, these lecturers must cooperate.
We have a total of 86 care sections. We want to assign a number of care sections to each lecturer based on the number of units he has during the semester, so that the lecturer who has the most units will have the least care section and vice versa, the lecturer who has the least number of units will have the most care sections.
How to do this in Excel?

 

[felixstraube]

Will something like this work?

Book1
	C	D	E	F	G
1		12
2		90.6	86		245.4
3	Lecturer	Units	Sections
4	Lecturer 1	12	0		0
5	Lecturer 2	11	0.350448248		1
6	Lecturer 3	9	1.051344743		3
7	Lecturer 4	8	1.401792991		4
8	Lecturer 5	8	1.401792991		4
9	Lecturer 6	7	1.752241239		5
10	Lecturer 7	7	1.752241239		5
11	Lecturer 8	6	2.102689487		6
12	Lecturer 9	5	2.453137734		7
13	Lecturer 10	3	3.15403423		9
14	Lecturer 11	3	3.15403423		9
15	Lecturer 12	2	3.504482478		10
16	Lecturer 13	2	3.504482478		10
17	Lecturer 14	2	3.504482478		10
18	Lecturer 15	2	3.504482478		10
19	Lecturer 16	2	3.504482478		10
20	Lecturer 17	1	3.854930725		11
21	Lecturer 18	0.6	3.995110024		11.4
22	Lecturer 19	0	4.205378973		12
23	Lecturer 20	0	4.205378973		12
24	Lecturer 21	0	4.205378973		12
25	Lecturer 22	0	4.205378973		12
26	Lecturer 23	0	4.205378973		12
27	Lecturer 24	0	4.205378973		12
28	Lecturer 25	0	4.205378973		12
29	Lecturer 26	0	4.205378973		12
30	Lecturer 27	0	4.205378973		12
31	Lecturer 28	0	4.205378973		12
Sheet1

Cell Formulas
Range	Formula
D1	D1	=MAX(D4:D31)
D2,G2	D2	=SUM(D4:D31)
E4:E31	E4	=G4/$G$2*$E$2
G4:G31	G4	=$D$1-D4

Are units of study and care sections of the same units? Like counted both in hours or something?

 

[felixstraube]

Or are you looking for something more like this?:

Should the units/sections be a rounded number? or can they be a fraction?

 

[mojtabapordel]

Thats great, Thank you so much