Run formulae on paired data

**batman98347** · 01-22-2015, 04:27 PM

Hi!

Just joined this forum as I have a difficult task to carry out using Excel (2013).

Let's say my data is in the form:

NAME DATA1 DATA2 DATA3 DATA4

1. AAAA 1 2 3 4
2. BBBB 5 6 7 8
3. CCCC 2 4 5 6
4. DDDD 4 5 6 7
5. EEEE 4 3 2 6

I wish to generate results such that EACH PAIR of rows are used in some formula (that I already have), and it produces a result. Example:

Results

1.Row_12
2.Row_13
3.Row_14
4.Row_15
5.Row_23 (I must skip Row_21 as this has already been done in 1.)
6.Row_24
etc.

NOTE: A row cannot be paired to itself.

Does anyone have any ideas how this can be done in Excel? Or can it not? Please feel free to ask more questions!

Thanks in advance!

**daffodil11** · 01-22-2015, 05:02 PM

I'd run this type of repeat calculation with VB.

Sub Permuations()

For i = 1 To 5
    For j = 1 To 5
        If j > i Then
            Range("D" & Rows.Count).End(xlUp).Offset(1) = Cells(i, 1) & Cells(j, 1)
        End If
    Next
Next

End Sub

A formula could be applied to include the references of each.

Run formulae on paired data

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Run formulae on paired data

Re: Run formulae on paired data

Thread Information

Users Browsing this Thread

Similar Threads

reorder paired data in rows

[SOLVED] Drag cell formula for paired data

[SOLVED] paired bar chart displaying difference as the data label

Need help creating scatter plot of paired data

summing averages of paired data

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions