My apologies, I'll try again with same data. So I want to generate the output in Column G without having to create columns E and F
| A | B | C | D | E | F | G |
---|
Item | Actual | Budget | Difference | Abs Diff | Rank | Running % | |
A | | | | | | | |
B | | | | | | | |
C | | | | | | | |
D | | | | | | | |
E | | | | | | | |
F | | | | | | | |
G | | | | | | | |
H | | | | | | | |
I | | | | | | | |
J | | | | | | | |
K | | | | | | | |
L | | | | | | | |
M | | | | | | | |
N | | | | | | | |
O | | | | | | | |
P | | | | | | | |
Q | | | | | | | |
R | | | | | | | |
S | | | | | | | |
T | | | | | | | |
U | | | | | | | |
V | | | | | | | |
| | | | | | | |
TOTAL | | | | | | | |
<colgroup><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]3[/TD]
[TD="align: center"]4[/TD]
[TD="align: right"] 7,310 [/TD]
[TD="align: right"] 9,700 [/TD]
[TD="align: right"] (2,390)[/TD]
[TD="align: right"] 2,390 [/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]98.9%[/TD]
[TD="align: center"]5[/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 1,100 [/TD]
[TD="align: right"] (1,100)[/TD]
[TD="align: right"] 1,100 [/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]99.7%[/TD]
[TD="align: center"]6[/TD]
[TD="align: right"] 16,104 [/TD]
[TD="align: right"] 16,362 [/TD]
[TD="align: right"] (258)[/TD]
[TD="align: right"] 258 [/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]99.9%[/TD]
[TD="align: center"]7[/TD]
[TD="align: right"] 32,209 [/TD]
[TD="align: right"] 21,600 [/TD]
[TD="align: right"] 10,609 [/TD]
[TD="align: right"] 10,609 [/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]64.1%[/TD]
[TD="align: center"]8[/TD]
[TD="align: right"] 47,553 [/TD]
[TD="align: right"] 64,800 [/TD]
[TD="align: right"] (17,247)[/TD]
[TD="align: right"] 17,247 [/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]48.2%[/TD]
[TD="align: center"]9[/TD]
[TD="align: right"] 2,655 [/TD]
[TD="align: right"] 5,400 [/TD]
[TD="align: right"] (2,745)[/TD]
[TD="align: right"] 2,745 [/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]91.1%[/TD]
[TD="align: center"]10[/TD]
[TD="align: right"] 16,105 [/TD]
[TD="align: right"] 21,600 [/TD]
[TD="align: right"] (5,495)[/TD]
[TD="align: right"] 5,495 [/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]84.2%[/TD]
[TD="align: center"]11[/TD]
[TD="align: right"] 18,948 [/TD]
[TD="align: right"] 10,800 [/TD]
[TD="align: right"] 8,148 [/TD]
[TD="align: right"] 8,148 [/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]70.2%[/TD]
[TD="align: center"]12[/TD]
[TD="align: right"] 26,941 [/TD]
[TD="align: right"] 16,200 [/TD]
[TD="align: right"] 10,741 [/TD]
[TD="align: right"] 10,741 [/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]56.2%[/TD]
[TD="align: center"]13[/TD]
[TD="align: right"] 378,182 [/TD]
[TD="align: right"] 351,000 [/TD]
[TD="align: right"] 27,182 [/TD]
[TD="align: right"] 27,182 [/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]20.3%[/TD]
[TD="align: center"]14[/TD]
[TD="align: right"] 35,024 [/TD]
[TD="align: right"] 32,400 [/TD]
[TD="align: right"] 2,624 [/TD]
[TD="align: right"] 2,624 [/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]97.1%[/TD]
[TD="align: center"]15[/TD]
[TD="align: right"] 106,419 [/TD]
[TD="align: right"] 86,400 [/TD]
[TD="align: right"] 20,019 [/TD]
[TD="align: right"] 20,019 [/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]35.3%[/TD]
[TD="align: center"]16[/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] - [/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]100.0%[/TD]
[TD="align: center"]17[/TD]
[TD="align: right"] - [/TD]
[TD="align: right"] 2,700 [/TD]
[TD="align: right"] (2,700)[/TD]
[TD="align: right"] 2,700 [/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]95.2%[/TD]
[TD="align: center"]18[/TD]
[TD="align: right"] 198,802 [/TD]
[TD="align: right"] 202,500 [/TD]
[TD="align: right"] (3,698)[/TD]
[TD="align: right"] 3,698 [/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]87.0%[/TD]
[TD="align: center"]19[/TD]
[TD="align: right"] 5,299 [/TD]
[TD="align: right"] 5,400 [/TD]
[TD="align: right"] (101)[/TD]
[TD="align: right"] 101 [/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]100.0%[/TD]
[TD="align: center"]20[/TD]
[TD="align: right"] 34,767 [/TD]
[TD="align: right"] 27,000 [/TD]
[TD="align: right"] 7,767 [/TD]
[TD="align: right"] 7,767 [/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]76.0%[/TD]
[TD="align: center"]21[/TD]
[TD="align: right"] 89,122 [/TD]
[TD="align: right"] 86,400 [/TD]
[TD="align: right"] 2,722 [/TD]
[TD="align: right"] 2,722 [/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]93.1%[/TD]
[TD="align: center"]22[/TD]
[TD="align: right"] 5,272 [/TD]
[TD="align: right"] 10,800 [/TD]
[TD="align: right"] (5,528)[/TD]
[TD="align: right"] 5,528 [/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]80.1%[/TD]
[TD="align: center"]23[/TD]
[TD="align: right"] 2,651 [/TD]
[TD="align: right"] 5,400 [/TD]
[TD="align: right"] (2,749)[/TD]
[TD="align: right"] 2,749 [/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]89.1%[/TD]
[TD="align: center"]24[/TD]
[TD="align: right"] 32 [/TD]
[TD="align: right"] 35 [/TD]
[TD="align: right"] (3)[/TD]
[TD="align: right"] 3 [/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]100.0%[/TD]
[TD="align: center"]25[/TD]
[TD="align: right"] 222 [/TD]
[TD="align: right"] 215 [/TD]
[TD="align: right"] 7 [/TD]
[TD="align: right"] 7 [/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]100.0%[/TD]
[TD="align: center"]26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"]27[/TD]
[TD="align: right"] 1,023,617 [/TD]
[TD="align: right"] 977,812 [/TD]
[TD="align: right"] 45,805 [/TD]
[TD="align: right"] 133,833 [/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
</tbody>