Hi, thanks to Xor Lx's support we have created a formula:
=SUMPRODUCT(N(VLOOKUP(T(IF({1},Sheet1!D2:D199)),Sheet2!A2:N199,14,0)<>Sheet1!R2:R199))
Thas works great, however only for defined range - only if there is 199 records, and when I extend the are for example to D200, this results in N/A error because there is blank cell.
So, we need to also INDEX function to find reference to last nonblank cell and sample formula for this is =INDEX($A:$A,2):INDEX($A:$A,MAX(MATCH(9.9E+307,$A:$A),MATCH(REPT("z",255),$A:$A)))
However, I am not able to connect this two formulas to make it work. Could you please help?
=SUMPRODUCT(N(VLOOKUP(T(IF({1},Sheet1!D2:D199)),Sheet2!A2:N199,14,0)<>Sheet1!R2:R199))
Thas works great, however only for defined range - only if there is 199 records, and when I extend the are for example to D200, this results in N/A error because there is blank cell.
So, we need to also INDEX function to find reference to last nonblank cell and sample formula for this is =INDEX($A:$A,2):INDEX($A:$A,MAX(MATCH(9.9E+307,$A:$A),MATCH(REPT("z",255),$A:$A)))
However, I am not able to connect this two formulas to make it work. Could you please help?