| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Intersect operations
Dear Community, I hope you can help... I have 2 MS Excel 1 column tables. I would like to perform an 'Intersect Operation' on both tables, thus creating one table of entries which appear in both of the original tables. EG. I want to create tableC = tableA AND tableB NOTE: I do not want to simply have the data of both tables joined together. This is a Union operation. I want data which appears in both A and B. NOT A or B. I understand a spreadsheet is not a database, but surely this is possible in MS Excel... if not, can anyone think of a speedy alternative??? -- heyes ------------------------------------------------------------------------ heyes's Profile: http://www.excelforum.com/member.php...o&userid=31506 View this thread: http://www.excelforum.com/showthread...hreadid=511839 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I add more dates to the employee operations timesheet | Excel Worksheet Functions | |||
| Operations with hidden cells | Excel Worksheet Functions | |||
| Document, if supported, operations with text arrays. i.e: count i. | Excel Worksheet Functions | |||
| how to get the intersect cell data out using vba or function | Excel Worksheet Functions | |||
| How do I perform operations within a funtion that operates on colu | Excel Discussion (Misc queries) | |||
Threaded Mode
