Hello! Me again Never stop asking questions
I need formula to EXACT compare rows from different sheets and different row ranges?
I have another formula wich serve me when i need compare two identycal ranges(tables): {=AND(EXACT(A1:D1,G1:J1))} double click to copy down, wich is great formula! I need something to Match rows(A1:D5) from Sheet1(non empty rows), find them inside Sheet2 in A1:D100, first column(A) is date formated. So, first Match date then Exact B,C,D columns, i dont know...
=IF(MMULT((A3:C7=Sheet2!E2:G19)*(A3:C7=Sheet2!E2:G19);1);"diff.";"Same!ok")
{=AND(EXACT(A22:C26;Sheet4!E2:G27))}
Book1.xlsx
I need formula to EXACT compare rows from different sheets and different row ranges?
I have another formula wich serve me when i need compare two identycal ranges(tables): {=AND(EXACT(A1:D1,G1:J1))} double click to copy down, wich is great formula! I need something to Match rows(A1:D5) from Sheet1(non empty rows), find them inside Sheet2 in A1:D100, first column(A) is date formated. So, first Match date then Exact B,C,D columns, i dont know...
=IF(MMULT((A3:C7=Sheet2!E2:G19)*(A3:C7=Sheet2!E2:G19);1);"diff.";"Same!ok")
{=AND(EXACT(A22:C26;Sheet4!E2:G27))}
Book1.xlsx
Last edited: