I got this close using Evolutionary Solver, changing col C to minimize max - min:

Row\Col
A
B
C
D
E
F
G
H
I
1
Wafer
Qty
Stack
1
2
3
4
2
0
0
0
0
3
wf01
522
2
0
522
0
0
D3: =D2 + (ROUND($C3, 0)=D$1)*$B3
4
wf02
526
4
0
522
0
526
5
wf03
542
2
0
1064
0
526
6
wf04
530
3
0
1064
530
526
7
wf05
579
1
579
1064
530
526
8
wf06
529
4
579
1064
530
1055
9
wf07
483
3
579
1064
1013
1055
10
wf08
477
3
579
1064
1490
1055
11
wf09
578
2
579
1642
1490
1055
12
wf10
558
1
1137
1642
1490
1055
13
wf11
522
3
1137
1642
2012
1055
14
wf12
430
3
1137
1642
2442
1055
15
wf13
571
4
1137
1642
2442
1626
16
wf14
554
2
1137
2196
2442
1626
17
wf15
504
2
1137
2700
2442
1626
18
wf16
528
4
1137
2700
2442
2154
19
wf17
579
2
1137
3279
2442
2154
20
wf18
560
1
1697
3279
2442
2154
21
wf19
478
3
1697
3279
2920
2154
22
wf20
572
4
1697
3279
2920
2726
23
wf21
522
4
1697
3279
2920
3248
24
wf22
499
3
1697
3279
3419
3248
25
wf23
565
1
2262
3279
3419
3248
26
wf24
531
1
2793
3279
3419
3248
max-min
27
wf25
557
1
3350
3279
3419
3248
171