Calling all pairs
March 9, 2010 12:21 PM Subscribe
Excel filter: Is there a simple way to iterate through all pairs in a list, perform a calculation on each pair, and sum the result?
posted by albrecht to Computers & Internet (11 answers total)
For example, I often need to do things like compute the sum all the possible pairwise products in a list. So if my data is X_1, X_2, X_3, I want X_1*X_2 + X_1*X_3 + X_2*X_3. Forgetting algebra tricks (which would depend on which function I was using), is there a simple way with Excel functions to address each pair, compute whatever I need, and add them up? I know how to do it in VBA, but I have the feeling there's a clever trick I'm missing.