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!