How to union ranges in google spreadsheets
Just use:
={sheet1!a:a; sheet2!a:a}
You can merge them into 1 column then get the unique values. Check the following formula:
=UNIQUE({Sheet1!A:A;Sheet2!A:A})
Just use:
={sheet1!a:a; sheet2!a:a}
You can merge them into 1 column then get the unique values. Check the following formula:
=UNIQUE({Sheet1!A:A;Sheet2!A:A})