Automate Comparison of Individual rows in a table

Solution 1:

What about this:

Formulas used:

• Combinations[ID]: =ROW()-ROW(Combinations[[#Headers],[ID]])
• Combinations[H1]: =SUM(([@ID]=HelpingTable[H1])*1) as an array formula (confirmed by CTRL+SHIFT+ENTER)
• Combinations[M1]: =SUM(INDEX([H1],1):[@H1])
• Combinations[M2]: =IF([@H1]=1,[@M1]+[@H1],OFFSET([@M2],-1,0)+1)
• Combinations[X1]: =INDEX(MeasurementTable[X],MATCH([@M1],MeasurementTable[Meas. No.],0))
• Combinations[Y1] and Combinations[Z1] just change letter inside []
• Combinations[X2]: =INDEX(MeasurementTable[X],MATCH([@M2],MeasurementTable[Meas. No.],0))
• Combinations[Y2] and Combinations[Z2] just change letter inside []
• Combinations[Difference]: =SQRT(([@X1]-[@X2])^2+([@Y1]-[@Y2])^2+([@Z1]-[@Z2])^2)

• HelpingTable[Meas.]: =ROW()-ROW(HelpingTable[[#Headers],[Meas.]])
• HelpingTable[H1]: =ABS(((MAX([Meas.])-[@[Meas.]]+1)-1)/2*(MAX([Meas.])-[@[Meas.]]+1)-45)+1

The MeasurementTable contains data only - no functions.

Stretch tables as needed.

Rows needed in the Combinations table: =COMBIN(<Measuremnt count>,2)