Nonparametric Pairwise Difference function in Excel

[theglassguy]

I'm looking to subtract each value from one column from all those in another. This is a non-parametric test called a "pairwise difference" and it is native in Minitab. Unfortunately, MiniTab costs $2,000, which is a bit stee for this one calculation. Does anyone know how to do this in Excel???

Ex:

8	1
3	2
6	10
4	4
6	1
4	8
2	9
11	1
13	20
22	3

I want to subract the first value (8) from all values in column 2, store them in column 3, then do the same thing with the second value in column 1 (3). I want it to stack the results in column 3, but I can do that manually.

Any help is appreciated!

~Aaron C