View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jennifer_C Jennifer_C is offline
external usenet poster
 
Posts: 1
Default calculate various cells to acheive a specific value

Hello,
I am trying to identify two cells within a column that total a specific
amount. For example:

ColA
546
9732
654
6548
687
9871

I need to find the two (or more cells in some cases) that would create the
total of 10,525.

For my current task, I have over 100 rows of data and I know two cells equal
a specific amount, but I do not know which two. Any help, or assistance given
would be greatly appreciated!

Jennifer