| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.access.queries,microsoft.public.excel.programming,microsoft.public.excel.querydao,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plus and minus in excel sheet | Excel Discussion (Misc queries) | |||
| TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
| how to color code a cell in excel if amount reaches a minus | Excel Discussion (Misc queries) | |||
| VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Linear Mode
