ExcelBanter - Equivalent of Minus in Excel. Also Union, Intersect.

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Equivalent of Minus in Excel. Also Union, Intersect. (https://www.excelbanter.com/excel-worksheet-functions/67954-re-equivalent-minus-excel-also-union-intersect.html)

Equivalent of Minus in Excel. Also Union, Intersect.

Try using an unmatched query.

" wrote:

Dear experts,

In excel, I have to find the differences between two sets of data.
Just like your set theory from grade 9 .

In one set, I have, say,

A
B
C
D
E
F

In the other set, I have,

D
E
F

Set one, minus set two is:
A
B
C

I would like to put the results of the minus into a new column.

In sql, you would just:

Query1
minus
Query2

But database is not an option here. The data is only in the
spreadsheet.

How can I do the same thing in excel?

Related to this, would be: Union, and Intersect.

Thanks