Adding Values

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

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!!
 
If you have to ask then you don't want to know the answer. <g>
http://www.tushar-mehta.com/excel/templates/match_values/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" <[email protected]>
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!!
 
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
 
Back
Top