Not the format you're looking for, but you could do this.
1. List your numbers in A1:A6.
2. Put one total number (such as 8) in G1.
3. Place this in B1, press ctrl/shift/enter, and fill
down to B6:
=IF(OR(A1+A1=$G$1,SUM(--(A1+$A$1:$A$6=$G$1))=0),"",MAX(IF
(A1+$A$1:$A$6=$G$1,$A$1:$A$6)))
All pairs (except numbers that equal themselves) that add
up to the total in G1 will appear.
HTH
Jason
Atlanta, GA
-----Original Message-----
i have the following spread sheet that reeds like this
Column A B C D
1
2
3
4
5
6
8 6 7
what would the formula be that would indicate which
cells (in column A)to
use to achive the total at the bottom of each column,
provided that each
number is only used once. this is a basic version of the
spreadsheet that i
am trying to calculate.
Regards
Ken
.
|