Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Values
I have a list of unique values that some portion of were previouslysummed to
a given value X. I need to find out which values in the list were added. Is there a formula or process that I might use find out which values were added? Thanks!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Values
If you have to ask then you don't want to know the answer. <g http://www.tushar-mehta.com/excel/te...ues/index.html has some possible ways to do it. My approach is to apply the amount against the oldest invoices. -- Jim Cone Portland, Oregon USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Sandy" wrote in message I have a list of unique values that some portion of were previouslysummed to a given value X. I need to find out which values in the list were added. Is there a formula or process that I might use find out which values were added? Thanks!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Values
Unique values does not imply unique sums. Lets say your unique values were
1,2,3,4 and the sum you got was 5. There is no way to look at the value 5 and figure out if it was the sum of 1 plus 4 or 2 plus 3... at least not unless (although with no guarantees) there were additional rules governing what gets summed and how. Rick "Sandy" wrote in message ... I have a list of unique values that some portion of were previouslysummed to a given value X. I need to find out which values in the list were added. Is there a formula or process that I might use find out which values were added? Thanks!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Values
Thanks to you both. I think this will at least get me something to look at.
"Sandy" wrote: I have a list of unique values that some portion of were previouslysummed to a given value X. I need to find out which values in the list were added. Is there a formula or process that I might use find out which values were added? Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding values of cells | New Users to Excel | |||
Adding values from a different worksheet | Excel Worksheet Functions | |||
Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
adding name values | Excel Worksheet Functions | |||
adding name values | Excel Discussion (Misc queries) |