ROW()/COLUMN() Function Formula Equivalent for an Array Created by Setting Two Distinct Ranges Equal to Each Other?

[MEUserII]

Consider the following data set:

R/C​	A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
1​		9​	8​	7​	6​	5​	4​	3​	2​	1​
2​	1​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	TRUE​
3​	2​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	TRUE​	FALSE​
4​	3​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	TRUE​	FALSE​	FALSE​
5​	4​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	TRUE​	FALSE​	FALSE​	FALSE​
6​	5​	FALSE​	FALSE​	FALSE​	FALSE​	TRUE​	FALSE​	FALSE​	FALSE​	FALSE​
7​	6​	FALSE​	FALSE​	FALSE​	TRUE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​
8​	7​	FALSE​	FALSE​	TRUE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​
9​	8​	FALSE​	TRUE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​
10​	9​	TRUE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​	FALSE​

Where there are two ranges entered:
$A$2:$A$10={1;2;3;4;5;6;7;8;9}
AND
$B$1:$J$1={9,8,7,6,5,4,3,2,1}

Now consider the array constructed by setting these two ranges equal to each other: ($A$2:$A$10)=($B$1:$J$1); this array has the following set of values:

(($A$2:$A$10)=($B$1:$J$1) )={FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,TRUE;FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,TRUE,FALSE;FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,TRUE,FALSE,FALSE;FALSE,FALSE,FALSE,FALSE,FALSE,TRUE,FALSE,FALSE,FALSE;FALSE,FALSE,FALSE,FALSE,TRUE,FALSE,FALSE,FALSE,FALSE;FALSE,FALSE,FALSE,TRUE,FALSE,FALSE,FALSE,FALSE,FALSE;FALSE,FALSE,TRUE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE;FALSE,TRUE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE;TRUE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE,FALSE}

Which for ease of visual representation we can enter in to B2 with Excel's spill feature visually representing the values "spilled" in to the other cells.
B2:= ($A$2:$A$10)=($B$1:$J$1)

The question is this: when I apply the ROW() function to $A$2:$A$10 and the COLUMN() function to $B$1:$J$1 I get the following:
ROW($A$2:$A$10)={2;3;4;5;6;7;8;9;10}
COLUMN($B$1:$J$1)={2,3,4,5,6,7,8,9,10}

However, when I apply either the ROW() function or the COLUMN() function to: ($A$2:$A$10)=($B$1:$J$1); I get an error.
ROW(($A$2:$A$10)=($B$1:$J$1) )=error
COLUMN(($A$2:$A$10)=($B$1:$J$1) )=error

So, my question is - is there an equivalent formula to the ROW()/COLUMN() function that for the array: ($A$2:$A$10)=($B$1:$J$1); will return {2;3;4;5;6;7;8;9;10}/{2,3,4,5,6,7,8,9,10}?

 

[bebo021999]

How about:
=ROW($A$2:$A$10)=COLUMN($B$1:$J$1)

 

[MEUserII]

How about:
=ROW($A$2:$A$10)=COLUMN($B$1:$J$1)

Thank you for the reply; that's not what I am looking for.

As an elaboration, I am looking for a formula, that takes the input of: ($A$2:$A$10)=($B$1:$J$1); and returns: {2;3;4;5;6;7;8;9;10} (ROW() function equivalent) OR {2,3,4,5,6,7,8,9,10} (COLUMN() function equivalent).

 

[Peter_SSs]

If you look at the syntax of the ROW function you will see that the argument (if used) must be a cell or range of cells.
What you are trying to feed into the function is an array of values, not a range, hence the problem.

The formula that you described in B2 =($A$2:$A$10)=($B$1:$J$1) places those array of values into a range, but that formula could be placed anywhere, not just in B2.
For example, below I have placed it in C4 so the rows used are now {4,5,6,....,12} not {2,3,4,...,10}

So, if you wanted the original rows you could use the formula that I have shown in M2 and if you want the rows of the array of values produced by the original formula you could use the formula structure that I have shown in N2 (though pointed at B2 for your described layout)

22 01 19.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		9	8	7	6	5	4	3	2	1
2	1												2	4
3	2												3	5
4	3		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE		4	6
5	4		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE		5	7
6	5		FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE		6	8
7	6		FALSE	FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE		7	9
8	7		FALSE	FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE		8	10
9	8		FALSE	FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE		9	11
10	9		FALSE	FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE		10	12
11			FALSE	TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
12			TRUE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE	FALSE
13
ROW

Cell Formulas
Range	Formula
M2:M10	M2	=ROW(A2:A10)
N2:N10	N2	=ROW(C4#)
C4:K12	C4	=($A$2:$A$10)=($B$1:$J$1)
Dynamic array formulas.