ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Adding Values (https://www.excelbanter.com/excel-worksheet-functions/186106-adding-values.html)

Sandy

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!!

Jim Cone[_2_]

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!!

Rick Rothstein \(MVP - VB\)[_381_]

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!!



Sandy

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!!



All times are GMT +1. The time now is 02:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com