I am trying do a row by row comparison of two separate sheets, and display the unequal rows on a third sheet. As an example, rows three and five on Sheet1
are different from Sheet2
and I want to display only them on Sheet3
.
SHEET1 SHEET2
A B C A B C
1 INT STR BOOL 1 INT STR BOOL
2 1 A TRUE 2 1 A TRUE
3 2 B FALSE 3 2 B TRUE
4 3 C TRUE 4 3 C TRUE
5 4 D FALSE 5 C 3 FALSE
So I would want Sheet3
to look:
SHEET3
A B C
1 INT STR BOOL
2 2 B FALSE
3 4 D TRUE
Right now the formula that I am using is this:
=ARRAYFORMULA(FILTER(IMPORTRANGE("URL1","A2:C5"), IMPORTRANGE("URL1","A2:C5")<>IMPORTRANGE("URL2","A2:C5")))
where the proper links have been substituted for "URL1" and "URL2" for brevity in the above formula. This formula is giving a #VALUE
error with the explanation:
FILTER range must be a single row or a single column.
Does anyone know a way to fix this?