finding matching pairs

I would like to find all matching pairs in the following example:

col
a b c d e f
a1 7 9 13 3 5 2
a2 3 6 11 2 8 5
a3 5 3 4 1 7 2

I can see for example that
3-2 in (a1) (a2) (a3)
7-5 in (a1) (a3)
3-5 in (a1) (a2) (a3)
and so on...

How can I set this up in excel?

Also, I am have a problem in sorting the rows from small to high
(a3) 5 3 4 1 7 2
to
(a3) 1 2 3 4 5 7

Can rows be sorted like columns?

Thanks ahead to all that helps me with this.

-dave

Not touching your first question.
2nd question, click on tools, sort and click on Options,
You can choose up/down or let/right.

"dave wagner" wrote:

> I would like to find all matching pairs in the following example:
>
> col
> a b c d e f
> a1 7 9 13 3 5 2
> a2 3 6 11 2 8 5
> a3 5 3 4 1 7 2
>
> I can see for example that
> 3-2 in (a1) (a2) (a3)
> 7-5 in (a1) (a3)
> 3-5 in (a1) (a2) (a3)
> and so on...
>
> How can I set this up in excel?
>
> Also, I am have a problem in sorting the rows from small to high
> (a3) 5 3 4 1 7 2
> to
> (a3) 1 2 3 4 5 7
>
> Can rows be sorted like columns?
>
> Thanks ahead to all that helps me with this.
>
> -dave
>
>
>

Hi everyone,

I have a similar question and would appreciate some assistance from anyone. Thank you.

I would like know how to create a table with a row for every combination of a set of variables
in order to identify students with matching answers for each variable


I have the following data:-

i) 18 months (Jan 2010 to June 2011)

ii) # of students in each month
- The survey respondents in this study are the same students for each month
but # of students for each month is either 7, 14, 15 or 16

iii) 6 questions / categories for each student.
- Each question has 20 possible answers (1, 2, 3, 4, 5, 6 until 20)
-


and would like to create a table with a row for each month/student/category combination

Q1 Q2 Q3 Q4 Q5 Q6
===========================================================================
2010 Dec Peter 2 4 11 5 15 16
2010 Nov David 12 4 10 2 14 18
2010 Oct Sam 4 17 19 20 13 5


List of matching answers
========================

Peter, David & Sam have matching answers

i) Peter Q1 & Q2 = David Q2 & Q4
ii) Peter Q2 & Q4 = Sam Q1 & Q6

thanks again for your assistance!

nat