S
sleek
I need to get the minimum or zero difference,
there are 3 constants here:-
GOAL to attains(constants)
456,270.00
525,400.00
522,600.00
DATA to use
A B C
41,150.00 55,200.00 53,250.00
53,250.00 58,100.00 53,250.00
53,250.00 62,950.00 67,760.00
65,840.00 62,950.00 67,800.00
67,800.00 69,720.00 87,150.00
96,850.00 147,200.00 193,600.00
147,200.00
523340.00 456120.00 522810.00 (total of column A,B,C)
525400.00 456270.00 522800.00 (constants)
-60 -150 210 Difference)
Anyone with formula or macro for me to get minimum or zero difference.
there are 3 constants here:-
GOAL to attains(constants)
456,270.00
525,400.00
522,600.00
DATA to use
A B C
41,150.00 55,200.00 53,250.00
53,250.00 58,100.00 53,250.00
53,250.00 62,950.00 67,760.00
65,840.00 62,950.00 67,800.00
67,800.00 69,720.00 87,150.00
96,850.00 147,200.00 193,600.00
147,200.00
523340.00 456120.00 522810.00 (total of column A,B,C)
525400.00 456270.00 522800.00 (constants)
-60 -150 210 Difference)
Anyone with formula or macro for me to get minimum or zero difference.