equation / function question
I have a column of unique numbers in ascending order:
A
B
C
D
E
F
etc....
I would like Excel to create another column consisting of all the
absolute differences of those numbers:
IE
A-B
A-C
A-D
A-E
A-F
B-C
B-D
B-E
B-F
C-D
C-E
C-F
D-E
D-F
E-F
I don't think this should be too hard, but I don't seem to be smart
enough to figure the syntax of the programming....
|