LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Need to get minimum difference

I need to get the minimum or zero difference,
there are 3 constants he-

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.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to determine the minimum difference between values? Eric Excel Discussion (Misc queries) 3 March 9th 09 05:25 AM
How to distribute coins to achieve minimum difference? Eric Excel Discussion (Misc queries) 0 August 29th 07 05:32 AM
How to lookup the minimum, 2nd minimum and 3rd minimum......... Mark McDonough Excel Worksheet Functions 8 July 15th 06 09:39 PM
charting a difference of 2 columns' w/o adding a difference column Wab Charts and Charting in Excel 4 July 27th 05 02:37 AM
Counting for Minimum Difference Value Michael168[_33_] Excel Programming 4 October 11th 03 02:36 PM


All times are GMT +1. The time now is 08:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"