SkywardPalm
Board Regular
- Joined
- Oct 23, 2021
- Messages
- 61
- Office Version
- 365
- Platform
- Windows
I'm working on a variance calculator and am in search of a way to Line up the matching sections and the proper variances. Where there are missing sections from previous/current, there should be blank cells rather than missing the blank sections and being unaligned with the wrong sections. Sometimes the names of sections are different, so the first 4 digits are all that should be accounted for.
The variance column is in order by section number and doesn't need aligning, so by creating blanks on each table should line up the sections properly. Right now the data is in pivot table but would probably need to be converted to a range of values?
Thanks in advance!
Here is a sample of what I am working with:
The variance column is in order by section number and doesn't need aligning, so by creating blanks on each table should line up the sections properly. Right now the data is in pivot table but would probably need to be converted to a range of values?
Thanks in advance!
Here is a sample of what I am working with:
Variance Sample.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
15 | |||||||||||
16 | Section | Value | Section | Value | Variance | ||||||
17 | 0100-Section Name | $ 38,476.81 | 0100-Section Name | $ 40,402.57 | $ (1,925.77) | ||||||
18 | 0101-Section Name | $ 6,000.40 | 0101-Section Name | $ 7,443.42 | $ (1,443.02) | ||||||
19 | 0102-Section-Name | $ 19,317.22 | 0102-Section-Name | $ 16,333.52 | $ 2,983.70 | ||||||
20 | 0103-SectionName | $ 33,311.79 | 0103-SectionName | $ 39,846.82 | $ (6,535.04) | ||||||
21 | 0104-SectionName | $ 10,400.92 | 0104-SectionName | $ 9,745.57 | $ 655.35 | ||||||
22 | 0105-Section Name | $ 3,264.62 | 0105-Section Name | $ 3,104.92 | $ 159.70 | ||||||
23 | 0106-Section-Name | $ 459.26 | 0106-Section-Name | $ 983.44 | $ (524.18) | ||||||
24 | 0108-Section Name | $ 5,238.30 | 0107-Section Name | $ 1,302.61 | $ (1,302.61) | ||||||
25 | 0109-Section Name | $ 55,984.04 | 0108-Section Name | $ 4,746.55 | $ 491.75 | ||||||
26 | 0112-Section Name | $ 3,496.50 | 0109-Section Name | $ 68,703.95 | $ (12,719.91) | ||||||
27 | 0113-Section Name | $ 9,134.66 | 0112-Section Name | $ 2,560.37 | $ 936.13 | ||||||
28 | 0115-Section Name | $ 839.55 | 0113-Section Name | $ 24,364.05 | $ (15,229.39) | ||||||
29 | 0117-Section Name | $ 51,027.32 | 0116-Section Name | $ 688.41 | $ 839.55 | ||||||
30 | 0118-Section Name | $ 7,182.32 | 0117-Section Name | $ 50,648.07 | $ (688.41) | ||||||
31 | 0120-Section Name | $ 10,670.10 | 0118-Section Name | $ 1,706.04 | $ 379.25 | ||||||
32 | 0121-Section Name | $ 4,206.46 | 0120-Section Name | $ 8,008.62 | $ 5,476.28 | ||||||
33 | 0124-Section Name | $ 667.59 | 0121-Section Name | $ 3,182.29 | $ 2,661.49 | ||||||
34 | 0125-Section Name | $ 18,846.50 | 0124-Section Name | $ 882.50 | $ 1,024.18 | ||||||
35 | 0126-Section Name | $ 2,296.16 | 0125-Section Name | $ 14,835.72 | $ (214.91) | ||||||
36 | 0200-Section Name | $ 21,864.70 | 0126-Section Name | $ 1,674.08 | $ 4,010.78 | ||||||
37 | 0300-Section Name | $ 8,507.14 | 0200-Section Name | $ 12,295.69 | $ 622.08 | ||||||
38 | 0301-Section Name | $ 2,218.88 | 0300-Section Name | $ 7,954.31 | $ 9,569.02 | ||||||
39 | 0302-Section Name | $ 284.69 | 0301-Section Name | $ 2,112.46 | $ 552.83 | ||||||
40 | 0303-Section Name | $ 320.90 | 0302-Section Name | $ 280.26 | $ 106.42 | ||||||
41 | 0400-Section Name | $ 95,540.36 | 0303-Section Name | $ 311.78 | $ 4.43 | ||||||
42 | 0500-Section Name | $ 25,857.53 | 0400-Section Name | $ 91,218.90 | $ 9.12 | ||||||
43 | 2000-Section Name | $ 13,346.58 | 0500-Section Name | $ 30,571.63 | $ 4,321.46 | ||||||
44 | 2100-Section Name | $ 2,341.24 | 0600-Section Name | $ 503.30 | $ (4,714.09) | ||||||
45 | Current Total | $ 451,102.55 | 2000-Section Name | $ 11,211.68 | $ (503.30) | ||||||
46 | 2100 - Section Name | $ 93,451.89 | $ 2,134.90 | ||||||||
47 | Previous Total | $ 551,075.40 | $ (91,110.65) | ||||||||
227 | |||||||||||
Main |