DisplayName
New Member
- Joined
- May 24, 2017
- Messages
- 10
Hello - I have data in range J3:v8. And another range from Y3:AV8. I want to subtract J3 from Y3, in columnd Z3, and K3 from AA3 in column AB3; essentially skipping the column before the range y3:av8. I've tried index columns, and offset(columns) function, and I just can't figure it out.
<colgroup><col span="12"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
GL | GL | GL | GL | GL | GL | GL | GL | GL | GL | GL | GL | GL | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | Invoice | Adjustment | |||
Jul-18 | Aug-18 | Sep-18 | Oct-18 | Nov-18 | Dec-18 | Jan-19 | Feb-19 | Mar-19 | Apr-19 | May-19 | Jun-19 | Total | Variance | Jul-18 | Jul-18 | Aug-18 | Aug-18 | Sep-18 | Sep-18 | Oct-18 | Oct-18 | Nov-18 | Nov-18 | Dec-18 | Dec-18 | Jan-19 | Jan-19 | Feb-19 | Feb-19 | Mar-19 | Mar-19 | Apr-19 | Apr-19 | May-19 | May-19 | Jun-19 | Jun-19 | Total | |
1,529.53 | 1,599.05 | 1,390.48 | 1,599.05 | 2,123.89 | 1,469.91 | 1,826.89 | 1,588.60 | 1,668.03 | 1,747.46 | - | - | 16,542.89 | - | - | 1,530 | - | 1,599 | - | 1,390 | - | 1,599 | - | 2,124 | - | 1,470 | - | 1,827 | - | 1,589 | - | 1,668 | - | 1,747 | - | - | - | - | 16,543 | |
1,232.33 | 1,288.35 | 1,120.30 | 1,288.34 | 1,056.00 | 1,108.80 | 1,324.80 | 1,152.00 | 1,209.60 | 1,267.20 | 1,324.80 | 1,152.00 | 14,524.52 | - | - | 1,232 | - | 1,288 | - | 1,120 | - | 1,288 | - | 1,056 | - | 1,109 | - | 1,325 | - | 1,152 | - | 1,210 | - | 1,267 | - | 1,325 | - | 1,152 | 14,524 | |
1,380.81 | 1,443.57 | 1,255.28 | 752.37 | 2,433.34 | 753.16 | 1,443.58 | 1,255.28 | 1,318.04 | 1,380.81 | 1,443.57 | 1,255.28 | 16,115.09 | - | - | 1,381 | - | 1,444 | - | 1,255 | - | 752 | - | 2,433 | - | 753 | - | 1,444 | - | 1,255 | - | 1,318 | - | 1,381 | - | 1,444 | - | 1,255 | 16,115 | |
1,619.20 | 1,692.80 | 1,472.00 | 1,692.80 | 1,619.20 | 952.39 | - | - | - | 1,872.62 | 1,910.77 | 1,661.54 | 14,493.32 | - | - | 1,619 | - | 1,693 | - | 1,472 | - | 1,693 | - | 1,619 | - | 952 | - | - | - | - | - | - | - | 1,873 | - | 1,911 | - | 1,662 | 14,494 | |
1,974.72 | 2,064.48 | 1,795.20 | 2,064.48 | 1,974.72 | 1,884.96 | 2,208.00 | 1,920.00 | 2,016.00 | 2,112.00 | 2,208.00 | 1,920.00 | 24,142.56 | - | - | 1,975 | - | 2,064 | - | 1,795 | - | 2,064 | - | 1,975 | - | 1,885 | - | 2,208 | - | 1,920 | - | 2,016 | - | 2,112 | - | 2,208 | - | 1,920 | 24,142 | |
- | - | - | - | - | - | - | - | - | - | 5,043.72 | 3,996.93 | 9,040.65 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | 5,044 | - | 3,997 | 9,041 |
<colgroup><col span="12"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>