finding matching pairs

[dave wagner]

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

 

[Guest]

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