Hello friends,
In columns k and l, a solution appears row after row, both give the same result, I am asking for one formula that will give the solution,Non-volatile and non-concatenated.
Thanks,
David
Hi ,
{=(A2:A7<>TRANSPOSE(B2:B7))*1}
I uploaded the solution in the file, and also the solution through a matrix, copy it into the file. And you will see the pairs you are looking for, the formula of the matrix is in cse.
Hi Aamir,
To understand exactly and give you a solution, take only 100 rows, and give an example of a range of 1,2,5 manually, how exactly do you want the solution to look. And what version of Excel do you have?
David
Hi shrivallabha,
I would like to make it clear that the data in the columns are unique data, and are not repeated more than once. If it were otherwise, then of course a different formula is needed.
David
Hi p45cal,
The lambda function is foreign to me, I haven't found time to learn, I hope to devote more effort to it. Thank you very much for your help.
David
Hello friends,
I want you to sort these two columns,
0
0
0
2
0
4
0
6
2
0
2
2
2
4
2
6
4
0
4
2
4
4
4
6
6
0
6
2
6
4
6
6
The minimum will appear in the first column, and the maximum in the second column...
Hello friends,
Does anyone know a way to avoid calculating #N/A cells?
=SUM(INDEX(COUNTIF(B1:B11,D1:D11&"<>#N/A"),0)) ,does not work ,
The correct result is 12
Thanks for the helpers
David
Hello friends,
Does anyone know a way to avoid calculating empty cells?
The range is fixed, the data changes, and there are empty cells,
These formulas do not work properly
=SUM(COUNTIF(B2:B43,D2:D43&"<>*"))
=SUM(COUNTIF(B2:B43,D2:D43&"<>"))
=SUM(COUNTIF(B2:B43,D2:D43&"*"))
Thanks for the...