View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] dhowell@daubert.com is offline
external usenet poster
 
Posts: 1
Default 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....