Here's one crack at it using non-array formulas ..

Sample construct available at:
http://cjoint.com/?behQIIGJEa
Locating and using twin pairs of numbers in a range_Carl_gen.xls

Assumptions made:
Source data in A1:I9
Only integers 0 - 9 (single digit)
Only 1 occurence of the "Pairs"
Pairs are identical in order, e.g: 2,4 and 2,4 (not for eg.: 2,4 and 4,2)

Placed in:
J1: =IF(COUNT(A1:I1)=2,"x","")
K1: =IF(J1="x",A1&B1&C1&D1&E1&F1&G1&H1&I1,"")
L1: =IF(K1="","",
IF(AND(COUNTIF($K$1:K1,K1)=2,LEFT(K1,1)<>RIGHT(K1,1)),"x",""))
M1: =IF(OR(COUNT(A1:I1)={0,2}),"",IF(COUNT(A1:I1)>2,"x",""))

Placed in N1, N1 copied to V1:
=IF(A1="","",IF(ISNA(MATCH("x",$L:$L,0)),A1,
IF(AND($M1="x",OR(A1=LEFT(INDEX($K:$K,MATCH("x",$L:$L,0)),1)+0,A1=RIGHT(INDE
X($K:$K,MATCH("x",$L:$L,0)),1)+0)),"",A1)))

J1:V1 selected and copied down to V9

N1:V9 returns the desired results, viz.:

> Row1 3 6 9
> Row2 1 3 6 9
> Row3
> Row4 2 4
> Row5 2 4
> Row6 1 5
> Row7 5 9
> Row8
> Row9 1 3 5 6 9

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Carl" <cscarlson@cox.net> wrote in message
news:1136337299.418063.184260@z14g2000cwz.googlegroups.com...
> I have an application that has a series of ranges based on nine rows
> and nine columns each (81 cells), and the cells are either blank or
> contain integers. I need to do two things with these ranges. I am
> moderately experienced with Excel and have a beginners knowledge of
> Visual Basic.
>
> 1. Identify which if any of the nine rows have two and only two numbers
> (not the same values), and that the two number pairs are identical. It
> does not matter which cells in the rows contain the identical number
> pairs, only that there are two rows with the same two numbers, and that
> the value of these two numbers are known. Call them Pairs.
>
> For example:
>
> A B C D E F G H I
>
> Row1 2 3 6 9
> Row2 1 2 3 6 9
> Row3
> Row4 2 4
> Row5 2 4
> Row6 1 5
> Row7 2 5 9
> Row8
> Row9 1 4 3 5 6 9
>
> Row 4 and 5 have two numbers and the pairs are identical (2 and 4)
>
>
> 2. Identify which rows have more than two numbers and contain the
> either of the pair values (2 and/or 4), and then delete the duplicate
> numbers from the rows.
>
> For example, delete the number 2 from Row2 ColC; delete the number 2
> from Row7 ColA; delete the number 4 from Row9 ColC.
>
> If anyone knows how to do this, I would be very grateful.
>
> Carl
>