I have two tables in Google Sheets
- Table A is always going to be smaller or equal size to Table B and is static
- Table B is updated daily from BigQuery so new values are added daily
Table A
A
B
C
Table B (Monday refresh)
A
B
C
E
F
Table B ( Tuesday refresh)
A
B
C
D
E
F
D
I want a formula which is adding to Table A only the missing values from Table B. So it checks the values of the cells previously in A and adds what is missing only.
So on Monday Table A will only add E – F and and on Tuesday it will only add D since they are the new cells from previous refresh without changing the data in the previous rows
I tried =ISNA(MATCH(A2:A, B2:B, 0)) and =FILTER(A2:A,ISNA(MATCH(A2:A,B2:B,0))) but it gives me error because I want the new value to be added in A4.
1